cannot name a cell

[PeCoNe]

If i try to name cell D6 to pSP5 it jumps to cell PSP5.
Can anybody tell me why?

 

[Claus Busch]

Hi Peter,

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.

 

[GS]

If i try to name cell D6 to pSP5 it jumps to cell PSP5.

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

 

[Claus Busch]

Hi Garry,

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.

 

[GS]

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.

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

 

[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

 

[PeCoNe]

PeCoNe schreef op 2014-06-05 14:42:

If i try to name cell D6 to pSP5 it jumps to cell PSP5.
Can anybody tell me why?

I named the cell pSPX and that is ok.
So problem solved.

Thanks all
Peter M.