Hello Aussie_Striker,
The most obvious problems I see in the code are the DIM statements need to be moved to the top of the Sub before any other code. Eventhough FOR ... NEXT loops will work without the index following NEXT statement, this is a bad programming practice, If you make these 3 changes, it will most likely fix your problem.
Sincerely,
Leith Ross
Bookmarks