Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I open a file with multiple sheets and have a formula or code return
the names of the sheets so i can perform calculations on varying sheets with out manually having to input them into my formulas. Example: i open a file created by anouther user that has 7 or 8 sheets with different names depending on the data in the sheets. I want to be able for my formulas to adjust to those names with having to input them in manually. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sheet selected, automatic return to top of sheet | Excel Worksheet Functions | |||
lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
return last value of a sheet | Excel Discussion (Misc queries) | |||
Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
How can I cause a cell to return the sheet name i.e. sheet 1? | Excel Worksheet Functions |