Name Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
I don't think anyone knows exactly what you want but to create a name for
a2:b10

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