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.

--
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

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