Name Range
 

I need to apply a range name to a2:b10 and create range names from the
selections rows and column labels. I have done that. But when I go to e3 to
verify that the range names are correct, I do not get =sheet1!$B$3. I get the
actual text. Does anyone know what I am doing wrong?
Thanks!

Name Range
 

I don't think anyone knows exactly what you want but to create a name for
a2:b10

range("a2:b10").name="myname"


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MAS_GSW" wrote in message
...
I need to apply a range name to a2:b10 and create range names from the
selections rows and column labels. I have done that. But when I go to e3
to
verify that the range names are correct, I do not get =sheet1!$B$3. I get
the
actual text. Does anyone know what I am doing wrong?
Thanks!