Name define

[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

 

[Tom Ogilvy]

I suspect you are mis-remembering, because offset requires a range reference
as the first argument.

 

[Alexander]

Thanks Tom. You are probably right. Do you know any other way for writing
that?

Tnx,

Alex

 

[Tom Ogilvy]

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.