Looping
 

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

Looping
 

Hi Gusset

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Gusset Gadder" wrote in message ...
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

Looping
 

"Ron de Bruin" wrote in message
...
Hi Gusset

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



Brilliant !!

Thank you so much