Executing a formula?

  • Thread starter Thread starter J S
  • Start date Start date
J

J S

Is there anyway to write a function that takes as input a string containing
a formula and then somehow executes it and returns the value?

MyExecuteFunction("sum(a2:c5)")

I basically want the user to write out a normal worksheet formula and then I
need to parse this formula, make some changes and return back the value.

Is there anyway to do this?
 
Hi
application.evaluate
e.g
msgbox application.evaluate("=SUM(A2:C5)")
 
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

Excel formula, sum the value cell and if empty cell left blank 0
Weighted randbetween text list 3
Macro for copy and paste function 2
Formula appearing as Value in Formula Bar 1
Write to intersect of a row and column 7
=TEXT fuction 2
HELP!!! I can't set formula to cell 1
How to do check for factors in formulas? 6

Back
Top