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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Name Range 4
Conditional formatting on a dynamic range - workaround 1
Drop Down with dynamic named range offsheet source list 14
Dependent drop down dynamic range formula, off sheet. 7
Sumproduct Indirect Named Dynamic Range using Offset 6
Excel VBA 1
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0

Back
Top