Excel won't loop through worksheets

[audioboxer]

I am trying to loop through all my work sheets and apply this code however it’s not looping through, it’s only working on the current sheet that’s open. Hoping someone here can help me out. Thank you.

Please Login or Register  to view this content.

[rollis13]

You need to activate the next sheet so add at least this row to your script:

Please Login or Register  to view this content.

[stanleydgromjr]

audioboxer,

When posting VBA code, please use Code Tags - like this:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]


Your code is only running on the active worksheet.

And, you do not have to activate a sheet, in order for the code to work correctly.

Please replace your posted code with the below code. If it does not work correctly, then please attach your workbook.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

[audioboxer]

You need to activate the next sheet so add at least this row to your script:

Please Login or Register  to view this content.

Thanks for your help. Worked perfect.

[rollis13]

Glad being of some help , but as said by stanleydgromjr, you do not need to activate or select the sheet if you change all your script as suggested.

[stanleydgromjr]

rollis13,

Thank you very much.

And, the code will execute faster because you do not have to Activate/Select a worksheet.