How to unname or change a named range

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

Guest

Can someone tell me how to rename or remove a name of a range of cells?

I wish to retry something and I cannot remove the name that was given

Thanks
 
Use menu command:
Insert | Names | Define; select the name to go and use Delete

best wishes
 
If you're going to work with names, get a copy of Jan Karel Pieterse's
(with Charles Williams and Matthew Henson) Name Manager

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
 
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

Unnaming cells already named 6
Finding unnamed cells in a range 3
Excel VBA setting Ranges 2
Can't located named range 3
How to Select A Cell in VBA with a Variable Row Number? 3
Moving a range name AND Contents 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Copy, Paste and Rename a Range using a macro 1

Back
Top