I'm sorry if this post is overlapping, because I could not find the older relevant posts.
In my excel file had an range named as "QD48" and was deleted long ago. Now I want to use the name "QD48" for another range in the same workbook, and Excel produces an error that "the name QD48 has already existed".
How can I treat this error? In fact, I deleted it in Name manager and its associate range as well.
Last edited by megaiooo; 08-25-2013 at 12:18 AM.
Select Ctrl+ F3
There you can edit, delete or create a new range.
Please click 'Add reputation', if my answer helped you.
Try running this macro:Hope this helps
Please Login or Register to view this content.
@ramananhrm: the OP already says that the name has been deleted from the Name Manager, so that wouldn't help in this case
QD48 cannot be used as a name for a range as it is a valid cell reference.
Help File
"Cell references disallowed Names cannot be the same as a cell reference, such as Z$100 or R1C1.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Cel QD48 does not exist in excel 2003, there you can use it.
But cel QD48 exist in excel 2007 there wil not work it
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Hahaha nice observation. Can't believe I missed that one!
I guess that will teach me to pay more attention to the OP's version of Excel in future!
OMG! I make a stupid mistake, I sometimes get the such mistakes.
Thank you all! specially, I would like to give sincere thank to Mr. Newdoverman, you're so excellent.
We all make mistakes and I have to admit that I have made that one myself a few times.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks