Hi Rick

First of all, I take your posting to mean you did not get the error message
that the OP got (in other words, my code ran "error" free on your system).

I got the same error: 9 Subscript out of range until I used the same
worksheet names in your code. Now it runs error free.

Thanks for your time and input.

Dan