2007 Assigning Range Names in one spreadsheet/worksheet
 

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

2007 Assigning Range Names in one spreadsheet/worksheet
 

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.

--
Jim
"bretsharon" wrote in message
...
|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

2007 Assigning Range Names in one spreadsheet/worksheet
 

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.

"Jim Rech" wrote:

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.

--
Jim
"bretsharon" wrote in message
...
|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