Convert a formula in a cell (written as string) to a formula

In a sheet, I have some cells where I write formulas as strings and “add” them together
for example:
W13 = “=(50*1*963)+”
W14= “0,002*5400*1*963)”
W16 = (B1&B2)
– so that to value in W16 = “=(50*1*963+0,02*5400*1*963)” – as a string.

Then I want a button to copy the value from W16 to a different sheet and convert it to formula so that the cell value will be = 152154, and when you press the cell you see the formula.

I use the follow code:

Sub PSP_Pris()

Range(“I7”) = “=SUM(I8:I11)”

Range(“I8”) = Sheets(“Beregner”).Range(“W16”)   ‘ Interne ressourcer, tilslutningsanlæg (Række 8)

Range(“I9”) = Sheets(“Beregner”).Range(“W29”)  ‘ Interne ressourcer, net forstærkning (Række 9)

Range(“I10”) = Sheets(“Beregner”).Range(“W32”) ‘ Eksterne omkostninger, tilslutningsanlæg (Række 10)

Range(“I11”) = Sheets(“Beregner”).Range(“W35”) ‘Eksterne omkostninger, net forstærkning (Række 11)

End Sub


But, when I enter the sheet “PSP” cell “I7” the cell is not automatically converted in to a formula and displaying the value as a number. I have to manly press the cell and press enter for the string in the cell to “convert” to a formula. The problem is that I have a lot of cells to go through this method, so I like to make the process happen automatically


Kind regards

By: Anders Skov Nielsen

24 thoughts on “Convert a formula in a cell (written as string) to a formula

  1. hermes handbags

    I have to express my thanks to this writer just for rescuing me from such a crisis. After browsing through the world wide web and finding notions that were not helpful, I was thinking my life was gone. Being alive minus the strategies to the issues you have sorted out by means of your good short article is a serious case, and the ones which might have badly damaged my career if I had not encountered the website. Your main skills and kindness in handling a lot of things was invaluable. I’m not sure what I would have done if I had not discovered such a step like this. I’m able to at this time relish my future. Thanks for your time so much for this high quality and results-oriented guide. I won’t hesitate to recommend your blog post to anybody who needs guidance about this problem.

  2. kobe 11

    I must show my appreciation to the writer for rescuing me from this particular dilemma. After scouting through the the net and getting ideas that were not productive, I was thinking my life was over. Existing devoid of the answers to the difficulties you’ve solved by means of your article is a crucial case, as well as the ones that would have in a negative way damaged my career if I had not discovered your web site. Your personal expertise and kindness in maneuvering every aspect was valuable. I am not sure what I would’ve done if I had not come upon such a stuff like this. I am able to at this time relish my future. Thanks a lot very much for your reliable and effective guide. I won’t think twice to refer the blog to anyone who would need assistance on this problem.

  3. Aurora

    Wow, wonderful weblog layout! How lengthy have you ever been running a blog for?
    you made running a blog glance easy. The overall glance of your website is wonderful,
    as neatly as the content material!

  4. yeezy 500

    I’m also commenting to make you be aware of of the cool encounter our daughter developed checking your web site. She came to find a good number of issues, most notably what it is like to possess a very effective helping heart to let a number of people very easily know just exactly specific multifaceted things. You really exceeded our desires. Thanks for producing those productive, trusted, edifying and even cool tips on the topic to Emily.

  5. nike shoes

    I wanted to draft you one tiny word to help say thanks as before for all the awesome tactics you’ve shown in this case. It has been particularly open-handed of you to offer freely what exactly a few people could possibly have advertised as an e book to end up making some cash on their own, primarily considering that you might have tried it in case you considered necessary. These concepts also acted like the good way to comprehend most people have similar interest just like my own to know very much more with regards to this matter. I believe there are numerous more fun sessions in the future for individuals who examine your site.

  6. hermes belt

    I would like to convey my appreciation for your generosity in support of folks that actually need help on this important niche. Your special commitment to passing the solution all-around appears to be remarkably advantageous and has all the time enabled employees like me to reach their ambitions. The valuable useful information signifies a great deal to me and somewhat more to my colleagues. Thank you; from each one of us.

  7. balenciaga speed

    I want to get across my love for your kindness in support of folks that need help on in this situation. Your very own dedication to getting the solution along came to be really helpful and have consistently made most people much like me to realize their targets. Your invaluable information means this much a person like me and especially to my fellow workers. Thank you; from everyone of us.

  8. curry 6

    I just wanted to develop a brief note to thank you for the stunning ideas you are giving on this website. My extended internet search has at the end of the day been paid with good quality ideas to share with my good friends. I ‘d repeat that we visitors are unequivocally endowed to dwell in a fantastic place with very many perfect individuals with very helpful solutions. I feel very blessed to have discovered your entire website page and look forward to plenty of more entertaining moments reading here. Thanks again for all the details.

  9. longchamp handbags

    I am glad for commenting to let you understand of the awesome discovery our princess developed reading through your webblog. She came to understand several pieces, which include what it is like to have a wonderful teaching mood to have other individuals smoothly understand some impossible subject areas. You really exceeded readers’ expectations. Thank you for coming up with those effective, trustworthy, educational and also easy thoughts on the topic to Tanya.

  10. cheap jordans

    I would like to convey my admiration for your kindness for those people that should have assistance with in this content. Your special dedication to getting the solution up and down appears to be remarkably good and have regularly permitted individuals like me to achieve their ambitions. The important recommendations denotes a whole lot a person like me and even further to my colleagues. Thank you; from all of us.

  11. golden goose sneakers

    I’m also writing to let you be aware of of the fantastic discovery my cousin’s princess gained reading yuor web blog. She even learned a good number of pieces, with the inclusion of what it is like to possess an ideal giving heart to make men and women without difficulty know just exactly specific multifaceted topics. You really exceeded her expectations. Many thanks for showing those warm and friendly, trustworthy, informative not to mention easy tips about the topic to Julie.

  12. supreme clothing

    Thank you a lot for providing individuals with remarkably breathtaking chance to read from here. It is always so brilliant and packed with amusement for me personally and my office peers to visit your site at the very least three times in one week to find out the latest stuff you will have. And lastly, I am also always satisfied considering the very good things you give. Some 4 areas in this post are particularly the finest we’ve had.

  13. curry 6

    My husband and i felt so ecstatic that Ervin managed to round up his preliminary research with the ideas he received from your web pages. It is now and again perplexing to simply possibly be releasing secrets and techniques which often people may have been selling. And now we take into account we’ve got you to appreciate for that. Most of the explanations you’ve made, the simple web site navigation, the friendships your site aid to instill – it’s mostly extraordinary, and it’s leading our son and the family know that that matter is pleasurable, and that is extremely serious. Many thanks for the whole lot!

  14. jordan 12

    My spouse and i were relieved when Chris could do his studies with the precious recommendations he got using your weblog. It’s not at all simplistic just to happen to be giving for free methods which people today have been selling. Therefore we take into account we have got you to give thanks to for this. Most of the illustrations you have made, the easy website navigation, the friendships your site help to instill – it’s everything powerful, and it’s really aiding our son in addition to us do think that issue is amusing, and that is extremely important. Thank you for all!

  15. adidas gazelle

    Thank you for your own hard work on this web site. Gloria enjoys working on investigation and it is easy to understand why. My spouse and i learn all of the compelling form you present invaluable secrets by means of the blog and as well boost participation from some other people on this theme and our simple princess is actually discovering a lot. Take advantage of the rest of the year. You are always performing a remarkable job.

  16. nike air max 90

    That is the correct weblog for anyone who desires to find out about this topic. You understand so much its almost exhausting to argue with you (not that I actually would need匟aHa). You definitely put a new spin on a subject thats been written about for years. Great stuff, just great!

  17. timberland outlet

    Aw, this was a very nice post. In concept I would like to put in writing like this moreover ?taking time and actual effort to make an excellent article?but what can I say?I procrastinate alot and certainly not appear to get one thing done.

  18. hermes birkin

    I was very pleased to seek out this net-site.I needed to thanks for your time for this glorious read!! I positively having fun with each little bit of it and I’ve you bookmarked to check out new stuff you blog post.

  19. jordan shoes

    Aw, this was a really nice post. In idea I would like to put in writing like this moreover ?taking time and precise effort to make an excellent article?but what can I say?I procrastinate alot and in no way seem to get one thing done.

  20. vans outlet

    I found your blog website on google and test a few of your early posts. Proceed to keep up the very good operate. I simply extra up your RSS feed to my MSN Information Reader. Looking for ahead to reading extra from you later on!?

Comments are closed.