Hi,

Commenting out that line seems to work fine on the copy I have. The currentrow variable processes until it reaches the value 37 where it exits the Do..Loop and goes on to the next Worksheet if there are any.

What makes you think it's not working? Have you tried stepping through it line by line to observe what happens?

Regards