Looping

[Gusset Gadder]

How do I perform the same set of command/functions on every worksheet in the
workbook without having to specify the worksheet names.
Must also work if I add or remove a sheet.

Thank you

 

[Ron de Bruin]

Hi Gusset

Dim sh as Worksheet
For Each sh In ThisWorkbook.Worksheets
'your code
Next sh

 

[Gusset Gadder]

Hi Gusset

Dim sh as Worksheet
For Each sh In ThisWorkbook.Worksheets
'your code
Next sh

Brilliant !!

Thank you so much