Select All worksheets in a workbook

[MrSnow]

Guys,

This is probably a really simple bit of code, and i'm pulling my hair out!!

I want to select every worksheet in a work book (approx 15) so that I can then carry out some standard formatting.

What I need to know is how to select the worksheets in the first place!!

Any suggestions?? All help is greatly appreciated!

 

[SteveO59L]

Hold down the shift key, and select first and last sheets

 

[MrSnow]

Thanks Steve,

But what if the size of the workbook increases at somepoint in the future (hypothetically) - the code would then need to be re-written. Is there a way of coding a generic "select all"???

Cheers

 

[DominicB]

Good afternoon MrSnow

Via code? Try this :

Sub test()
Worksheets.Select
End Sub

HTH

DominicB

 

[MrSnow]

lol, so simple i'm almost embarrassed....

Thank you very much Dom