Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect returns #REF! regardless of where it is used.
I searched the forums for reasons why the INDIRECT function may return
REF. The only answer I found was that it will return REF id it is trying to access a closed workbook. In my case, the INDIRECT returns REF regardless of where it is used. For example, if I open a new workbook and type in cell A2 the following: =INDIRECT(A1), it will return #REF!. Any help would be appreciated. cheers. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect returns #REF! regardless of where it is used.
The INDIRECT function works with text.
Try this: =INDIRECT("A1") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Shaz" wrote: I searched the forums for reasons why the INDIRECT function may return REF. The only answer I found was that it will return REF id it is trying to access a closed workbook. In my case, the INDIRECT returns REF regardless of where it is used. For example, if I open a new workbook and type in cell A2 the following: =INDIRECT(A1), it will return #REF!. Any help would be appreciated. cheers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect function - Limitations | Excel Worksheet Functions | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Problem with GEOMEAN - returns #NUM error | Excel Worksheet Functions | |||
When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |