Thread: Name define
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alexander[_4_] Alexander[_4_] is offline
external usenet poster
 
Posts: 6
Default 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