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