How can I correct color index errors?
 

Run Time error 1004 - Unable to set ColorImdex propert of the interior class


How can I resolve this Macro problem?

How can I correct color index errors?
 

Hi
post the code snippet that causes this error

"Mpakateni" wrote:

Run Time error 1004 - Unable to set ColorImdex propert of the interior class


How can I resolve this Macro problem?

How can I correct color index errors?
 

If you are using Excel 97 and you are doing this from a commandbutton, try
changing the takefocusonclick property of the commandbutton to false.

--
Regards,
Tom Ogilvy

"Mpakateni" wrote in message
...
Run Time error 1004 - Unable to set ColorImdex propert of the interior
class


How can I resolve this Macro problem?