![]() |
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? |
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