Name define

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
 
T

Tom Ogilvy

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

Alexander

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

Tnx,

Alex
 
T

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