Hi snb,
This has been extremely helpful. I have tweeked it further to convert the cells with numbers stored as text into numbers as you advised and tested it in several different situations (different folders). I have one problem that occurs with some folders and not others and I don't know what's causing it.
I get an error message stating "Run-time error '1004' Application-defined or object-defined error" at this part of the code:
When I add On Error Resume Next in the line before it the error does not appear, but also nothing seems to happen. But when I put the macro in a new excel workbook everything worked. Could you please let me know how to resolve this?
Thanks again for all your help.
abousetta
Bookmarks