how can i select all sheets in excell?

[Bob Umlas]

.. ctrl/shift/spacebar
.. ctrl/A twice
.. Click the blank square above row 1 & to the left of col A
.. in VBA: cells.select

 

[Mike H]

Pres and hold CTRL and left cleck each sheet tab in turn

Mike