| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I refer to sheet number not sheet (name)?
xl-2007
In a worksheet formula, is there a way to refer to another worksheet by index number an not by it's given name? I'd rather not us VBA if possible. Thanks. DK |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I refer to sheet number not sheet (name)?
The short answer is no, you'd need VB Code for this. But, there are a few
tricks, such as inserting hidden sheets, or creating a dynamic list of sheet names that may work. It really depends what you need to do. If you share some more details on what you're trying to accomplish, perhaps we could make a suggestion. HTH Elkar "DK" wrote: xl-2007 In a worksheet formula, is there a way to refer to another worksheet by index number an not by it's given name? I'd rather not us VBA if possible. Thanks. DK |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I refer to sheet number not sheet (name)?
Elkar,
Thanks for the reply. I found code for returning sheet names using a UDF "OffsetSheet()". I'll play around with it. Thanks again. DK "Elkar" wrote in message ... The short answer is no, you'd need VB Code for this. But, there are a few tricks, such as inserting hidden sheets, or creating a dynamic list of sheet names that may work. It really depends what you need to do. If you share some more details on what you're trying to accomplish, perhaps we could make a suggestion. HTH Elkar "DK" wrote: xl-2007 In a worksheet formula, is there a way to refer to another worksheet by index number an not by it's given name? I'd rather not us VBA if possible. Thanks. DK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refer to a sheet using a cell value | Excel Worksheet Functions | |||
| Refer to Previous or Next Sheet | Excel Worksheet Functions | |||
| Countif - refer to another sheet | Excel Worksheet Functions | |||
| Refer new sheet to previous sheet | Excel Worksheet Functions | |||
| Refer to sheet name specified in other cell | Excel Discussion (Misc queries) | |||
Linear Mode
