ExcelBanter - Need group all sheets in a workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need group all sheets in a workbook (https://www.excelbanter.com/excel-programming/316981-need-group-all-sheets-workbook.html)

TOMB

Need group all sheets in a workbook

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 - -

AA2e72E

Need group all sheets in a workbook

Try:

ActiveWorkbook.Sheets.Select

"TOMB" wrote:

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 - -

TOMB

Need group all sheets in a workbook

Thanks!

"AA2e72E" wrote:

Try:

ActiveWorkbook.Sheets.Select

"TOMB" wrote:

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 - -

All times are GMT +1. The time now is 04:10 AM.