sassafrasy
New Member
- Joined
- Oct 29, 2002
- Messages
- 2
I have begun receiving the following errors on my worksheets, and I was hoping y'all might tell me how to avoid them:
"Unable to set the ColorIndex property of the Interior class" (err # 1004); "Unable to set LineStyle property.." (err #1004); and "Too many different cell formats" (err #1004)
Granted I have been coloring and bordering some things in my sheets, but it really isn't that much-- I promise.. just coloring a few tables and bordering a few of the headers. Why exactly am i getting this error, and are there ways to avoid it? I feel like excel is erroneously punishing me-- like it thinks there are many more different cell formats going on on my sheets then there really are.
any help, thoughts, comments are greatly appreciated
thanks!
-michael
"Unable to set the ColorIndex property of the Interior class" (err # 1004); "Unable to set LineStyle property.." (err #1004); and "Too many different cell formats" (err #1004)
Granted I have been coloring and bordering some things in my sheets, but it really isn't that much-- I promise.. just coloring a few tables and bordering a few of the headers. Why exactly am i getting this error, and are there ways to avoid it? I feel like excel is erroneously punishing me-- like it thinks there are many more different cell formats going on on my sheets then there really are.
any help, thoughts, comments are greatly appreciated
thanks!
-michael