received error: Too many different cell formats

[jeff p]

Hello,

I've just recently ran into this Error (Runtime error 1004)
"Too many different formats."


I'll admit i have a ton of cell formats within my single worksheet.
perhaps most are for artistic purposes.

Still, my worksheet as it is causes this error, when running my scripts. When I wipe out all my format color, boarders, etc. my scripts run fine.

Is there a maximum amount of cell formats that can be used?
I'm using Excel 2003

Is there a way to circumvent this?

Not sure if using Excel 2007 is an option:
I've tried opening my project in 2007, but found that all my buttons were missing, plus it seemed to run considerably slower.

any ideas?

thanks

Jeff