P
PeCoNe
If i try to name cell D6 to pSP5 it jumps to cell PSP5.
Can anybody tell me why?
Can anybody tell me why?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Claus Busch
Hi Peter,
Am Thu, 05 Jun 2014 14:42:45 +0200 schrieb PeCoNe:
in the newer versions this is a cell address and addresses are not
allowed for names.
Try
PSP_5
Regards
Claus B.
Am Thu, 05 Jun 2014 14:42:45 +0200 schrieb PeCoNe:
If i try to name cell D6 to pSP5 it jumps to cell PSP5.
in the newer versions this is a cell address and addresses are not
allowed for names.
Try
PSP_5
Regards
Claus B.
G
GS
If i try to name cell D6 to pSP5 it jumps to cell PSP5.
Are you specifying 'local scope' (sheet level)? PSP5 is probably global
scope (workbook level) and so takes precedence. You should never create
global scope names unless *absolutely* necessary! You can ref a name on
another sheet by prepending the sheetname like so...
='Another Sheet'!NamedRange
...where "NamedRange" refs the range defined with local scope on
Sheets("Another Sheet").
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Can anybody tell me why?
Are you specifying 'local scope' (sheet level)? PSP5 is probably global
scope (workbook level) and so takes precedence. You should never create
global scope names unless *absolutely* necessary! You can ref a name on
another sheet by prepending the sheetname like so...
='Another Sheet'!NamedRange
...where "NamedRange" refs the range defined with local scope on
Sheets("Another Sheet").
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
C
Claus Busch
Hi Garry,
Am Thu, 05 Jun 2014 09:27:01 -0400 schrieb GS:
since xl2007 the worksheet range is A1:XFD1048576.
So PSP5 is a cell address.
Regards
Claus B.
Am Thu, 05 Jun 2014 09:27:01 -0400 schrieb GS:
='Another Sheet'!NamedRange
since xl2007 the worksheet range is A1:XFD1048576.
So PSP5 is a cell address.
Regards
Claus B.
G
GS
Hi Peter,
Quite correct! I didn't think of it due to not using newer version so
much until recently. I see last col label is "XFD" in 2010! Regardless,
just another issue that confirms using local scope names but not if a
col label...
Sheet1!s_PS5
...works!
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Am Thu, 05 Jun 2014 14:42:45 +0200 schrieb PeCoNe:
in the newer versions this is a cell address and addresses are not
allowed for names.
Try
PSP_5
Regards
Claus B.
Quite correct! I didn't think of it due to not using newer version so
much until recently. I see last col label is "XFD" in 2010! Regardless,
just another issue that confirms using local scope names but not if a
col label...
Sheet1!s_PS5
...works!
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
G
GS
Typo...
Example should've been "p_SP5"!
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Example should've been "p_SP5"!
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
P
PeCoNe
PeCoNe schreef op 2014-06-05 14:42:
So problem solved.
Thanks all
Peter M.
I named the cell pSPX and that is ok.If i try to name cell D6 to pSP5 it jumps to cell PSP5.
Can anybody tell me why?
So problem solved.
Thanks all
Peter M.