Menu

Using Macro, want to group all Worksheets, but Sheet1,How?

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

Using Macro, want to group all Worksheets, but Sheet1,How?

glad to help

--
Don Guillett
SalesAid Software

"Dandelo" wrote in message
...
Wow!, thank you, Don. that did it!
--
Thank you so much for your help!

"Don Guillett" wrote:

try
Sheets(1).Select

--
Don Guillett
SalesAid Software

"Dandelo" wrote in message
...
I want to use the code name to reference Sheet1, the Sheet is named
something
else and the name will continue to change.

Also, the first line keeps failing with ,<type mismatch:

Sheets(Sheet1).Select
--
Thank you so much for your help!

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Saving worksheets using a Macro	lqfong	Excel Discussion (Misc queries)	1	June 27th 06 01:10 PM
group sheets with macro in excel	jannkatt	Excel Discussion (Misc queries)	2	May 18th 06 02:43 PM
Group & Outline in Protected Worksheets	mkf	Excel Discussion (Misc queries)	1	May 14th 06 03:34 PM
Is it possible to permanently group worksheets	bennyob	Excel Discussion (Misc queries)	1	October 31st 05 02:43 PM
Is it possible to create a macro to group?	Mike Piazza	Excel Discussion (Misc queries)	1	January 8th 05 12:23 AM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement