Name define
Thanks Tom. You are probably right. Do you know any other way for writing
that?
Tnx,
Alex
"Tom Ogilvy" wrote in message
...
I suspect you are mis-remembering, because offset requires a range
reference
as the first argument.
--
Regards,
Tom Ogilvy
"Alexander" wrote in message
...
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
|