| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Macro, want to group all Worksheets, but Sheet1,How?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Macro, want to group all Worksheets, but Sheet1,How?
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Macro, want to group all Worksheets, but Sheet1,How?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving worksheets using a Macro | Excel Discussion (Misc queries) | |||
| group sheets with macro in excel | Excel Discussion (Misc queries) | |||
| Group & Outline in Protected Worksheets | Excel Discussion (Misc queries) | |||
| Is it possible to permanently group worksheets | Excel Discussion (Misc queries) | |||
| Is it possible to create a macro to group? | Excel Discussion (Misc queries) | |||
Linear Mode
