Posted to microsoft.public.excel.programming

external usenet poster

Posts: 25

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Name a group of sheets	Mary Ann	Excel Discussion (Misc queries)	2	November 26th 09 10:59 PM
sort between a group of sheets	tkincaid	Excel Worksheet Functions	8	January 6th 09 03:42 PM
group excel sheets within workbook	melbournedude1	Excel Discussion (Misc queries)	4	February 13th 06 12:53 PM
Group Sheets	Brian Keanie	Excel Discussion (Misc queries)	10	January 1st 05 08:34 PM
Sheets Protection for group!!!!?	Simon Lloyd[_488_]	Excel Programming	3	June 16th 04 12:12 PM

All times are GMT +1. The time now is 01:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us