| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with - Sheets(Array(1, 2, 3)).Select
I can select several sheets with
Sheets(Array(1, 2, 3)).Select but if i ned to select many sheets, say abot 100 how do i add the array to do that without writing 1,2,3,4,5,6,7,... manualy ? by the way is it possible to just add say from 2-45 and 60 to 99 ? I cant figure this out, so any help would be greatfull thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sheets(array).select problem | Excel Discussion (Misc queries) | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| Select sheets from an array for printing | Excel Discussion (Misc queries) | |||
| Using an array to select data | Excel Programming | |||
| Select Sheets via Array Macro | Excel Programming | |||
Threaded Mode
