Loop Worksheets

[magician]

Can anyone help me with writing code to loop through the worksheets in a workbook? Not quite sure how to do this?

Thanks

 

[MrKowz]

Not sure exactly what you need, but from what you explain, this might help:

Sub WorksheetLoop()
Dim ws as Worksheet
For each ws in ActiveWorkbook.Worksheets
     'INSERT CODE HERE
Next ws
End Sub

 

[VoG]

It would be something like

Sub WSLoop()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
' Code to do something here
Next ws
End Sub