Clinton,
The feedback is appreciated.
A note... If you were to start running the code over large ranges -
thousands of rows/dozens of columns - then the code would need tweaking
to reduce the memory load. The string array construction is not optimized.
Sincerely,
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)





"Whois Clinton"

wrote in message
Jim,
I cannot thank you enough for your help. I have been counting up to 1500
cells in 25 workbooks and was anticipating another 160 workbooks every year.
You have saved me weeks of counting and also made me look quite computer
savy. Everything you recomended worked and worked well.
Thanks again!!!
Clinton




"Jim Cone" wrote:
You are welcome.
The use of Option Explicit in all modules is strongly recommended.
It acts like "Lassie" who would start barking and then herd you away from the
hidden mine shaft you were about to fall into. To add it automatically to all modules...
In the VBE go to Tools | Options | Editor (tab) and checkmark the
"Require Variable Declaration" button.

As far as checking for any colored background in a cell, you can simply
determine if the cell interior has no color...
Change...
If c.Interior.ColorIndex = 6 Then
To...
If c.Interior.ColorIndex < xlColorIndexNone Then
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)





"Whois Clinton"

wrote in message
WOW That works even without adding the "Option Explicit". How about if I
didn't care what the color was just whether or not there was a color? This
way I wouldn't have to copy and rewrite this for every color. Thanks so much
already!