Name define

  • Thread starter Thread starter Alexander
  • Start date Start date
A

Alexander

I can not define the name with relative refference. I remember that I
created (long time ago) something as:

MyName
=Sheet1!Offset(-2,0)

Now I can't (returns error). Only if I write:
=Sheet1!Offset(G10,-2,0)
but am sure that I didn't work on that way before.

Any hit about that?


Tnx in advance,

Alex
 
I suspect you are mis-remembering, because offset requires a range reference
as the first argument.
 
Thanks Tom. You are probably right. Do you know any other way for writing
that?

Tnx,

Alex
 
Not anyway other than using the proper syntax - I guess a good answer would
depend understanding what it is that you are really trying to do.
 
Back
Top