I had an earlier post and thought I had an answer. I am trying to reference a
sheet in a workbook in a cell from a different sheet using the sheet
position for the reference. i.e. =sheet(1)A20
i received a reply that =INDIRECT(SHEETNAME(1) & "A3") would do this for me.
Unless is used it incorrectly, I get a #value when using the Indirect
function as shown. I am using Office 2003, not 2007 if that makes a
difference.
Thanks in advance.
--
jwm