|I'm glad you worked it out.|
I may have mentioned this before, but I'll mention it again because it is important...
You should try to eliminate the use of Select in your code. Rarely, if ever, do you need to Select an Excel object to perform a VBA operation on it. Selecting objects seriously slows your code down and makes it very inefficient.
All of the Selects also make the code cumbersome to read and follow while debugging.
The following 2 snippets do the same thing, but the second one is a much more efficient method.
Imagine reading through a very long macro with lots of Copy operations. Which method would you rather read?
Which one is easier to read and gets the reader to the point faster? VBA feels the same way.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.