Is the sheet protected?
Jim Cone


"Chris L"
wrote in message
Hi again,
I tried to replace "Range" with "Cells" and the application doesn't
terminates anymore. It's very strange though,... the syntax are valid and it
doesn't seem to be any mistakes.
I still cannot solve the Interior Class problem (Color/ColorIndex), does
anyone know how to change the cell color with macro in Excel 97?
Regards,
Chris