ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Process Worksheets (https://www.excelbanter.com/excel-programming/298720-process-worksheets.html)

dfrancefort[_2_]

Process Worksheets
 
I need to process worksheets in a workbook. Is there a
way to loop through all of the worksheet names in an open
workbook?

[email protected]

Process Worksheets
 
Dim wSht as Worksheet

For Each wSht in ActiveWorkbook.Worksheets
' Your processing code here.
Next wSht

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I need to process worksheets in a workbook. Is there a
way to loop through all of the worksheet names in an open
workbook?




All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com