I want to change the font color of a string that is a variable.
This is my attempt, which generates an "Invalid qualifier" error.
The "sActual" is invalid. (Probably because its a string).
I was able to change the font color via, Sh4Cell.Font.Color = "value", but that did not allow the attribute to stay with the value stored in sActual.Please Login or Register to view this content.
How can I set the font attribute and maintain that attribute as I paste the value (sActual) in other areas of the workbook?
Macro sample:
Any hints, tips or examples are appreciated.Please Login or Register to view this content.
Bookmarks