Need group all sheets in a workbook

G

Guest

I have several workbooks that I will need to open and group all sheets
regardless of sheet name and number of sheets. I concidered something like:
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
but of course that is too specific to the sheet names and number of sheets.

Thanks in advance for the help!

- -TB - -
 

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

Insert rows in grouped sheets 2
Error Message - Macro to Unlink MS Queries from Workbook 0
Junp start my Select Case Macro 12
Auto fill Sheets 1
Change event code Find .Activate does not activate Target.value 4
group all sheets after 3
clear all sheets code 4
Automated Copy Paste 1

Top