2007 Assigning Range Names in one spreadsheet/worksheet

  • Thread starter Thread starter bretsharon
  • Start date Start date
B

bretsharon

I know how to assign range names in 2003, but can't find it in 2007. Help
only wants to talk about range names in another workbook
 
I think you might have been mislead by the "scope" dropdown in the New Name
dialog. Unless you want to have a new name be visible only on a specific
sheet you can just ignore it, leaving it as "workbook". Just enter the name
at the top and the Refers To at the bottom.
 
Say what? ...Using your words though I cam across the dialog box and read
the help file so I got what I needed. thank you.
 
You must log in or register to reply here.

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

Setting Scope of name ranges to particular worksheet 2
2007 XL Delete Range Name 1
Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
Conditional formatting when text is contained in a named range 2
version differences in excel 2007 - use of macros & range names 1
name the range of data 3
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Back
Top