cannot name a cell

  • Thread starter Thread starter PeCoNe
  • Start date Start date
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.
Click to expand...

in the newer versions this is a cell address and addresses are not
allowed for names.
Try
PSP_5


Regards
Claus B.
 
If i try to name cell D6 to pSP5 it jumps to cell PSP5.
Can anybody tell me why?
Click to expand...

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
 
Hi Garry,

Am Thu, 05 Jun 2014 09:27:01 -0400 schrieb GS:
='Another Sheet'!NamedRange
Click to expand...

since xl2007 the worksheet range is A1:XFD1048576.
So PSP5 is a cell address.


Regards
Claus B.
 
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.
Click to expand...

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
 
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?
Click to expand...
I named the cell pSPX and that is ok.
So problem solved.

Thanks all
Peter M.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
How to keep formula and be able to input value in cell? 0
Excel JUMP FROM SEARCH BAR TO RESULT 3
"ICC-Aware" 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
A macro to check range and then check another range if falset-then 2
if blank 5
macro to check if cells have values in them...then 4

Back
Top