Using VBA to name cells from the value in another cell

I have a workbook where I need to name a range of cells. Lets call it “Data”. Each cell within the range needs a unique descriptive name so it can be easily referenced from other worksheets. I have the naming worked out and have populated a range 10 columns over with values equal to what i want the cells in my range to be named. We can call that range “Names”. How can I use the values from Names to change the cell names of the cells in Data?

I have googled this and found bits of code related but I am not a VBA expert and haven’t been able to get anything to work

By: Tony

50 thoughts on “Using VBA to name cells from the value in another cell

  1. nike air max 270

    My husband and i got so relieved Louis could do his survey through the precious recommendations he gained when using the web pages. It’s not at all simplistic just to find yourself giving out steps which usually other people might have been trying to sell. And we understand we have got you to be grateful to because of that. These explanations you’ve made, the easy website menu, the relationships your site help to promote – it is many awesome, and it’s really helping our son and the family imagine that this issue is interesting, which is certainly quite vital. Thank you for the whole lot!

  2. off white shoes

    I simply had to say thanks once more. I am not sure the things I would’ve followed in the absence of the type of pointers documented by you regarding such question. Completely was a very hard setting in my circumstances, but noticing the specialized avenue you resolved that took me to weep for delight. I am just happier for the help and thus expect you comprehend what a powerful job you are accomplishing educating the mediocre ones with the aid of a blog. More than likely you’ve never met all of us.

  3. ig

    Attractive portion of content. I just stumbled upon your weblog and in accession capital to
    claim that I get in fact enjoyed account your weblog posts.

    Anyway I will be subscribing in your feeds and even I achievement
    you get entry to consistently quickly.

  4. kobe sneakers

    Needed to draft you this very small remark to help give many thanks yet again relating to the breathtaking pointers you have shown on this page. It’s quite wonderfully generous of you to convey openly exactly what numerous people would’ve marketed for an ebook to end up making some bucks on their own, most notably considering the fact that you could possibly have done it if you ever desired. The pointers in addition served to become a fantastic way to be certain that the rest have similar fervor the same as my very own to know the truth a whole lot more when considering this matter. I am sure there are thousands of more pleasurable opportunities up front for individuals who start reading your blog post.

  5. off white

    I intended to put you that little note to say thanks a lot once again with the wonderful methods you have provided above. It’s pretty generous with people like you to supply publicly precisely what most people might have sold for an e book to get some bucks for themselves, specifically seeing that you could possibly have tried it in case you decided. These strategies likewise worked to become a great way to realize that many people have similar fervor the same as my personal own to find out somewhat more with respect to this matter. Certainly there are several more enjoyable times ahead for those who check out your blog post.

  6. golden goose

    I definitely wanted to make a small message so as to say thanks to you for all of the marvelous solutions you are giving out here. My time intensive internet investigation has at the end been rewarded with good insight to exchange with my close friends. I would express that many of us website visitors are definitely blessed to dwell in a good network with so many wonderful professionals with great points. I feel very grateful to have seen your website page and look forward to some more brilliant moments reading here. Thank you once again for everything.

  7. jordans

    Thanks a lot for providing individuals with such a spectacular opportunity to read in detail from this web site. It’s usually so great and as well , full of a good time for me and my office acquaintances to visit your blog at the least 3 times in one week to find out the newest tips you have. And of course, I am also certainly happy for the good pointers served by you. Some two facts in this posting are unequivocally the most effective we’ve ever had.

  8. sling tv

    When someone writes an piece of writing he/she maintains the idea of a
    user in his/her brain that how a user can understand it.
    So that’s why this paragraph is amazing. Thanks!

  9. nike air max 97

    Thank you a lot for providing individuals with remarkably spectacular opportunity to discover important secrets from this site. It really is so fantastic and packed with amusement for me and my office colleagues to search the blog particularly 3 times weekly to read through the latest items you will have. And definitely, I’m so always happy with the amazing opinions served by you. Certain two points in this post are in fact the finest I have ever had.

  10. sling tv

    Spot on with this write-up, I absolutely believe this website needs far more attention. I’ll probably be back again to read more, thanks
    for the information!

  11. sling tv

    An impressive share! I have just forwarded this onto a colleague who had been conducting a little
    homework on this. And he actually bought me lunch
    because I stumbled upon it for him… lol. So allow me to reword
    this…. Thanks for the meal!! But yeah, thanks for spending time to
    talk about this matter here on your internet site.

  12. yeezy boost 350

    My husband and i were so relieved Emmanuel could carry out his homework via the ideas he discovered using your weblog. It is now and again perplexing just to always be giving for free guides the rest may have been selling. We really take into account we need the website owner to be grateful to because of that. The type of illustrations you made, the straightforward site navigation, the relationships you can make it easier to promote – it’s mostly spectacular, and it is aiding our son and the family reason why this article is awesome, which is incredibly important. Thanks for all the pieces!

  13. Todd Snively

    Once I originally commented I clicked the -Notify me when new feedback are added- checkbox and now each time a remark is added I get four emails with the same comment. Is there any approach you possibly can remove me from that service? Thanks!

  14. Todd Snively

    you’re in point of fact a excellent webmaster. The web site loading speed is amazing. It kind of feels that you are doing any distinctive trick. In addition, The contents are masterpiece. you’ve performed a great job in this subject!

  15. cheap jordans

    I enjoy you because of all your work on this web page. My mom loves engaging in internet research and it’s really easy to understand why. We all hear all relating to the compelling mode you deliver very important guides on the blog and in addition improve participation from other individuals on this situation and our child is actually becoming educated a lot. Take advantage of the remaining portion of the new year. You’re doing a stunning job.

  16. sling tv

    Hey there I am so happy I found your blog page, I
    really found you by mistake, while I was researching on Aol for
    something else, Anyhow I am here now and would just like to say thanks a lot for a fantastic post and a all
    round exciting blog (I also love the theme/design), I don’t have
    time to look over it all at the moment but I have book-marked it
    and also included your RSS feeds, so when I
    have time I will be back to read a great deal more, Please do keep
    up the great work.

  17. lebron 15 shoes

    I as well as my friends appeared to be examining the best ideas located on your web page then the sudden I had an awful feeling I never thanked the web blog owner for those techniques. Those men are already as a consequence very interested to study them and have sincerely been having fun with these things. Thanks for indeed being so considerate and for having some terrific ideas most people are really desperate to be informed on. Our own sincere regret for not expressing gratitude to earlier.

  18. Isiah

    Valuable info. Fortunate me I found your web site by chance, and I am stunned why this twist of fate didn’t came about in advance! I bookmarked it.

  19. balenciaga shoes

    My husband and i ended up being so ecstatic that Jordan could deal with his web research from your precious recommendations he grabbed while using the web pages. It’s not at all simplistic to just find yourself offering guidelines some others might have been selling. We really do know we now have the website owner to appreciate for that. The main illustrations you made, the straightforward web site menu, the relationships you will make it easier to create – it is many excellent, and it is facilitating our son and us reckon that that content is fun, which is certainly incredibly pressing. Many thanks for everything!

  20. On Page SEO Expert

    Howdy! This is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us beneficial information to work on. You have done a outstanding job!


    Hi there this is kind of of off topic but I was wanting
    to know if blogs use WYSIWYG editors or if you have to manually code with HTML.
    I’m starting a blog soon but have no coding knowledge
    so I wanted to get guidance from someone with experience.
    Any help would be enormously appreciated!

  22. yeezys

    I want to express my appreciation to this writer just for rescuing me from this particular challenge. After searching throughout the internet and obtaining tips that were not pleasant, I figured my entire life was done. Existing devoid of the approaches to the difficulties you have solved all through the short post is a serious case, and those that could have in a negative way damaged my entire career if I hadn’t encountered the website. Your good training and kindness in controlling all the pieces was very helpful. I don’t know what I would’ve done if I hadn’t discovered such a solution like this. I’m able to at this time relish my future. Thanks very much for your high quality and results-oriented help. I won’t be reluctant to endorse your web page to any person who needs guide on this issue.

  23. longchamp handbags

    My wife and i ended up being happy when Ervin managed to conclude his researching out of the precious recommendations he gained from your very own weblog. It’s not at all simplistic just to choose to be releasing helpful tips which often other people might have been making money from. And now we keep in mind we have the website owner to thank because of that. All of the illustrations you’ve made, the straightforward blog menu, the relationships you will make it easier to instill – it is all unbelievable, and it’s really facilitating our son in addition to our family recognize that that situation is interesting, which is certainly pretty important. Many thanks for everything!

  24. kd shoes

    Thank you for all your valuable hard work on this web page. Gloria loves conducting internet research and it’s really obvious why. We notice all regarding the dynamic tactic you present sensible steps via the website and as well as encourage participation from some others about this matter plus my girl is without a doubt learning a great deal. Take pleasure in the remaining portion of the new year. Your carrying out a dazzling job.

  25. supreme hoodie

    I intended to send you that very little observation just to thank you so much the moment again for all the wonderful methods you’ve shown in this case. This is simply strangely open-handed with people like you in giving openly what a lot of people could have sold as an e book to make some cash for their own end, principally given that you could possibly have tried it in the event you considered necessary. These creative ideas also worked like a good way to realize that other people online have similar fervor much like my own to learn way more on the subject of this condition. I am sure there are thousands of more pleasant opportunities up front for individuals that go through your website.

  26. Antonio Freimark

    There are some interesting points in time in this article but I don?t know if I see all of them center to heart. There is some validity but I will take hold opinion until I look into it further. Good article , thanks and we want more! Added to FeedBurner as well

  27. ps4 games

    Every weekend i used to go to see this site, because i wish for enjoyment, since this this website conations in fact pleasant
    funny material too.

  28. yeezy

    I’m often to blogging and i actually admire your content. The article has really peaks my interest. I’m going to bookmark your web site and hold checking for new information.

  29. nike shox

    I抦 impressed, I have to say. Really hardly ever do I encounter a blog that抯 each educative and entertaining, and let me tell you, you have hit the nail on the head. Your thought is excellent; the difficulty is one thing that not sufficient persons are speaking intelligently about. I am very completely satisfied that I stumbled across this in my search for something regarding this.

  30. lebron 17 shoes

    An fascinating dialogue is worth comment. I feel that you must write more on this matter, it may not be a taboo topic but usually people are not enough to speak on such topics. To the next. Cheers

  31. supreme new york

    Good post. I study something more difficult on different blogs everyday. It’s going to all the time be stimulating to learn content from other writers and observe just a little something from their store. I抎 desire to make use of some with the content on my weblog whether or not you don抰 mind. Natually I抣l provide you with a hyperlink in your internet blog. Thanks for sharing.

  32. are coconut oil

    Hello! This is my 1st comment here so I just wanted to
    give a quick shout out and say I genuinely enjoy reading through your blog posts.
    Can you suggest any other blogs/websites/forums that go over the same subjects?


    whoah this weblog is great i like studying your articles.
    Stay up the great work! You recognize, lots of individuals
    are looking around for this information, you could help them

  34. timberlands

    After research a couple of of the weblog posts in your website now, and I actually like your approach of blogging. I bookmarked it to my bookmark web site checklist and will likely be checking back soon. Pls check out my site as nicely and let me know what you think.

Comments are closed.