Search found 2 matches

by bryan.d.wilkins
Thu Jan 24, 2019 10:33 pm
Forum: XLSReadWritwII 6
Topic: ActiveCell.Characters(Start:=1, Length:=14).Font
Replies: 2
Views: 5624

Re: ActiveCell.Characters(Start:=1, Length:=14).Font

Thank you Larsa. Worked well.
by bryan.d.wilkins
Mon Jan 21, 2019 7:05 am
Forum: XLSReadWritwII 6
Topic: ActiveCell.Characters(Start:=1, Length:=14).Font
Replies: 2
Views: 5624

ActiveCell.Characters(Start:=1, Length:=14).Font

I need to set the first 14 characters in a cell to font yellow and the remaining characters to font black. The following code is how it would be done using an Excel marco/ole. Anyone know how to do it in XLSReadWrite? With ActiveCell.Characters(Start:=1, Length:=14).Font .Name = "Century Gothic...