Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect sheet reference in a cell
Is there a way to write an equation to use the values from a specific cell on
another worksheet without using the worksheet name. i.e. reference it by position in the workbook, such as "Sheet(1)" as is done in Visual Basic? -- jwm |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect sheet reference in a cell
First enter this UDF:
Function sheetname(i As Integer) As String sheetname = Sheets(i).Name & "!" End Function and then: =INDIRECT(sheetname(1) & "A9") will return the value in cell A9 in the first worksheet. -- Gary''s Student - gsnu200776 "velvetlady" wrote: Is there a way to write an equation to use the values from a specific cell on another worksheet without using the worksheet name. i.e. reference it by position in the workbook, such as "Sheet(1)" as is done in Visual Basic? -- jwm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell reference OR INDIRECT function | Excel Worksheet Functions | |||
How do I use an indirect reference to a sheet in another workbook? | Excel Discussion (Misc queries) | |||
Cell reference within a indirect.. | Excel Worksheet Functions | |||
Indirect reference to another sheet that can be dragged | Excel Worksheet Functions | |||
indirect function to reference cell on different sheet | Excel Worksheet Functions |