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

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