INDIRECT

D

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?
 
J

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?
Click to expand...

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

Jerry Whittle

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