Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
I'd like to define a collection of sheets that includes every sheet in the workbook except the first sheet. I recorded that, and it did it with an Array... Sheets (Array("Sheet2", "Sheet3", "Sheet4")).select , for example. But, when I wrote the program to determine the array, it didn't work... in a couple of ways. So, I tried it with a sheets variable defined as an array but I'm having trouble with it. there are a collection of files, to which I need to make some changes to every sheet in the file, other than the first sheet. I'd like to do some of the changes in group mode, if possible. Is there a good way to do something like Sheets(Sheet1!2:8).select ? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data collection | Excel Discussion (Misc queries) | |||
Collection | Excel Programming | |||
How to find the type of Sheet in Excel.Workbook.sheets collection | Excel Programming | |||
Is a Collection the best option? | Excel Programming | |||
Sum textboxes in a collection | Excel Programming |