Multi Sheet Macro

  • Thread starter Thread starter Dan
  • Start date Start date
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??
 
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
 
Hi Dan

Jeff's solution does work - it's just

sheets.select

nothing else

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Message - Macro to Unlink MS Queries from Workbook 0
clear all sheets code 4
Array code only works on selected sheet 14
Macro to Combine Data from Multiple Sheets with Cell References 4
Code copies twice...? 13
Change event code Find .Activate does not activate Target.value 4
Copy Array to Array, how to and should I? 13
Run macro from active workbook whose name keeps changing 20

Back
Top