Great stuff, thanks again to you two guys!

"PMC1" wrote:

Use something like With Worksheets(Activesheet)

this will work with any worksheet.

There is no worksheets(All) as all the worksheets is really the
workbook collection

DannyS wrote:
I have a macro that contains the line:

With Worksheets("UK")

Can I get it to apply to all my worksheets?

Ie

With Worksheets(All)

Thanks!