| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referring to Sheet locations in a formula
In VBA, sheets can be referred to by either name or location.
Example: Sheets("Sheet2").Activate or Sheets(2).Activate Is there a way to refer to sheet locations in a formula? For example, I'd like to sum cell C1 on sheets 2 through 10 (the last sheet will be determined in a cell on sheet1). I'm thinking it will be an array, but I'm not sure about referring to sheet locations in a formula. Thanks In Advance. Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula referring to a different sheet | Excel Discussion (Misc queries) | |||
| Referring to a list in one sheet to another column on a different | Excel Discussion (Misc queries) | |||
| Referring to the previous selected sheet in a macro | Excel Discussion (Misc queries) | |||
| Changing Formula Locations | Excel Discussion (Misc queries) | |||
| referring to previous sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
