Hi All,

I'm a complete novice when it comes to VBA code however I've pieced together this code. It performs the first section of the code before issuing the "Subscript out of range" error. I think it fails around the WS2.activate line.

I was wondering if someone could maybe shed some light on whats going wrong and how to fix?

Code :

Please Login or Register  to view this content.
Thanks in advance