Search found 2 matches
- 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.
- 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...