Long time reader, first time poster!
I'm having an interesting bug... in vba, Characters.delete only works on cells that have less than 255 characters, but I can change the color with no problem. Check this out... post this in a workbook in cells A1 and A2 respectively:
Then select A1 and run this macro:Please Login or Register to view this content.
See how it works fine for the first entry, but the second only colors, but doesn't delete font?Please Login or Register to view this content.
How can I work around this?
Bookmarks