Excel 2007 Named Range - Naming convention

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

I just got a message that I can't use the following names in Excel 2007

POP1, POP2, etc.

and that they were being changed to _POP1, _POP2, etc.

What's the reason for that?

Thanks,
Barb Reinhardt
 
They look too much like cell addresses.

xl2003 had headers A:IV
xl2007 has A to lots of columns. And POP1 is row 1 in column POP.
 

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

SaveCopyAs and FileType 3
VBAProjects still open for workbooks closed in Excel 2007 1
Activate PowerPoint from Excel 1
Centered Overlay Title in VBA 1
Excel 2003 to 2007 Gotchas ... so I can be prepared 5
Excel 2007 and Declaring Variables 2
Excel 2003 to 2007 Migration Question 1
Creating Named Ranges with VBA 5

Back
Top