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.

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.
>
>

Awesome solution! Thank you!