INDIRECT

[danielh]

Hi!
I´ve used INDIRECT in a worksheet in several places.
Now when I open it a month later they won´t work.
And when I open a new worksheet and type:
A1:1
A2:=INDIRECT($A$1)
I get an #ref-error.
What´s this? Have I got a total brain loss and use the command in a wrong
way? Or has something happend with my excel?

 

[John W. Vinson]

Hi!
I´ve used INDIRECT in a worksheet in several places.
Now when I open it a month later they won´t work.
And when I open a new worksheet and type:
A1:1
A2:=INDIRECT($A$1)
I get an #ref-error.
What´s this? Have I got a total brain loss and use the command in a wrong
way? Or has something happend with my excel?

I'd suggest you repost your question in a forum supporting Excel. This forum
is for the database program Microsoft Access. The webpage can be confusing and
may have misled you.

 

[Jerry Whittle]

This is an Access database forum. You need to ask your question in an Excel
spreadsheet forum.