Looping Through Worksheets

[markkramer]

I need to create a macro that loops through all the worksheets in a workbook. Each workbook will have an unknown number of worksheets and each worksheet will have an unknown name. The macro will need to:

1. Loop to the next worksheet
2. Open the worksheet (then I'll add code to do things in the worksheet)
3. Store the name of the worksheet in a variable
4. Repeat through all the worksheets

I know what to do once I get the worksheet open but I haven't figured out how to loop through each worksheet nor save the worksheet name in a variable.

Would appreciate help!

Thanks!

M

 

[dafan]

Try this

Dim ws as Worksheet
Dim WorksheetName as String
 
For Each ws in Worksheets
 
WorksheetName = ws.Name ' This will store the sheetname in the variable
 
< your code here >
 
 
Next 'Go to next worksheet

 

[markkramer]

Wow! That was really quick -- and exactly the answer I was looking for. Thanks!!!!