When I select h1 and goto the name box (left of formula box) and put in joe
without sheet name or quotes the defined name.refers to box =Sheet7!$H$1
When I insertnamedefinetype in Bill and enter $h$2 in the refers to box,
I get =Sheet7!$H$2
When I do the macro below I get the same result
Sub doname()
Range("h3").Name = "Sam"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dave Peterson" wrote in message
...
I've never seen that behavior and I can't get xl2003 to do it now.

You aren't writing about the "refers to" area are you?

I meant the "Names in workbook" area.

Don Guillett wrote:

It has been my experience with xl2003 that when you type in the name in
either place, IF you are on the desired sheet, excel will FILL IN the
sheet
name for you.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dave Peterson" wrote in message
...
Yes.

When you name the range--either by typing in the namebox (to the left
of
the
formula bar) or by using the Insert|name dialog, make sure you include
the
name
of the sheet.

'Sheet 1'!Area1

(since "Sheet 1" (with the space character) requires the name be in
single
quotes/apostrophes.)



"Bruce A. Julseth" wrote:

Can I use a name twice in a workbook, only in different sheets? That
is
to
say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have
Name
"Area!" for "Sheet2!$A$1:$F$14"

I tried the above but it didn't work. I'm not sure if it can't be done
or
I
did something wrong.

Thanks for the help..

--

Dave Peterson

--

Dave Peterson