Macro compatibility with Excel 97
No, it's not protected.
Anyway, as replacing "Range" to "Cells" prevents it from crashing,
I'm happy with it.
Thank you for your assistance.
Regards,
Chris
"Jim Cone" wrote:
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
|