| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selection of several worksheeets
Hi
I'd like to select several excel worksheets using a VBA macro. I know: Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select But how can I do it without specifying each sheet name? For example using something like ... from sheet 3 to sheet 8 ... .Select? If possible, please help me. Thank you. Entaf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
| Changing Selection for the "Center Across Selection" alignment | Excel Discussion (Misc queries) | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
![Enrico[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
