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.

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

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

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.

--
Regards,
Tom Ogilvy

"Alexander" wrote in message
...
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