Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet referencing in a cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet referencing in a cell
You need to install the UDF before you can use it in the worksheet:
UDFs are very easy to install and use: 1. ALT-F11 brings up the VBE window 2. ALT-I ALT-M opens a fresh module 3. paste the stuff in and close the VBE window If you save the workbook, the UDF will be saved with it. To use the UDF from the normal Excel window, just enter it like a normal Excel Function To remove the UDF: 1. bring up the VBE window as above 2. clear the code out 3. close the VBE window To learn more about UDFs, see: http://www.cpearson.com/excel/Writin...ionsInVBA.aspx -- Gary''s Student - gsnu200777 "velvetlady" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing every 5th cell in another sheet | Excel Worksheet Functions | |||
referencing to a sheet that it`s name is stored on a cell | Excel Worksheet Functions | |||
odd behavior when referencing a cell on another sheet | Excel Discussion (Misc queries) | |||
referencing Excel sheet name in cell | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions |