I am glad that helped. Could I interest you into some advice though?


Excel is the Application and with in it, can be one or more workbooks.
Ideally one of those workbooks is yours, while the others are not. Instead
of referring to Application.Worksheets, be more specific and use
Activeworkbook.Worksheets.

When creating code in modules, always drill to your target from
activeworkbook. You do not have to be so diligent in the code panes for
ThisWorkbook, Sheet1, Sheet2 ... ect, as they already stem from the
activeworkbook.

By being specific, you learn to type really long usless code quickly with
lots of typos. No seriously, you allow your project to co-exist with other
projects harmoniously, and still get the expected results.

"Joe" wrote in message
oups.com...
Superb! Brilliant! Splendid!!!!!!

thanks a lot, my friend!

It works perfectly!

And to answer your question, I had been getting error messages like :

"Compile error: method or data member not found"

Thanks again,

Joe.