Is the sheet protected. No reason it shouldn't work on an unprotected
sheet.

--
Regards,
Tom Ogilvy

"Erwin" wrote in message
...
A macro developed and running ok under Offixe/XP prodcues
Run time error 1004 "Unable to set Colour Index for
Interior Class" when the spreadsheet macro is run on a PC
running XP but EXCEL prior to Office XP. I have beleive
the problem VB statement a

Set Rng = ActiveSheet.Range("B6:U55")
Rng.Interior.ColorIndex = xlNone

A work around would be appreciated.