Looping through various worksheets VBA

Hello,

I am looking to create a loop to run through all the worksheets in my workbook to run some code that clears the contents of "blank cells".

The code works for the active worksheet but doesn't seem to run through the loop to the next one.

Please Login or Register  to view this content.

Thanks for any help

Matt

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M