Multi Sheet Macro

D

Dan

I have a Workbook with 20 individual sheets. Each Sheet
has two Buttons. One is a clear the other is a Clear all
Sheets. The Clear All basicly selects all the sheets and
runs the clear button.

Sheets (Array("sheet 1", sheet 2", etc, "Sheet 20")).Select

what I want to do to reduce code and file size is
something like:

Sheets(Array("Tech 1:Tech 25")).Select

but I can't get that to work. Suggestions??
 
D

Dan

Sheets.select("Sheet 1:Sheet 20") doesn't work

Sheets ("Sheet 1:Sheet 20").Select doesn't work

sheet (Array( ... nothing

Sheet.Select (Array( ... nada

Errors out
 
J

JulieD

Hi Dan

Jeff's solution does work - it's just

sheets.select

nothing else

Cheers
JulieD
 
Top