Hi Ryan H.,
GREAT! Your information was very helpful!
Unfortunately the suggestion to use:
ActiveCell.Interior.Color = 10079487
did not work either. (It resulted in a yellow cell.)
But on reading your link I solved the issue by applying:
ActiveWorkbook.ResetColors
first.
Thanks!
M.
Ryan H wrote:
Forgot about the other question. Take a look at this link from Microsoft on
changing the Color Palette.
http://office.microsoft.com/en-us/ex...989351033.aspx
Can Anyone shine a light on this:
[quoted text clipped - 26 lines]
Michiel
--
Message posted via
http://www.officekb.com