Name define
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 |
Name define
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 |
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 |
Name define
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 |
All times are GMT +1. The time now is 02:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com