If you are following instructions correctly then you should have 1 module with the code from post #5, and another module with the code from post #7.1. Opened VBA and selected insert>module and pasted all the codes you said so there should be 3 seperated by lines correct?
But in post 5 there are 2 codes aren't there?If you are following instructions correctly then you should have 1 module with the code from post #5, and another module with the code from post #7.
You're very welcome! Best of luck with the rest of the translating.
Are all files in a single directory?Hi Jon...this is a great script. I have multiple worksheets in a directory and would love to run this on entire directories. My guess it would look through..any assistance would be helpful. Thanks in advance.