Forum Discussion
COMMAND TO RUN A FORMULA?
Good afternoon, Excel gurus! I am trying to "assemble" a formula and am wondering if there is a way to create a formula that tells Excel to run the formula in the last cell where it's a finished pro...
Hi Ronna,
You need to a special solution to calculate this formula string IF($A$7=4*3,50,99).
My suggestion is to use the following custom function that I wrote in VBA and save in the workbook in a new VBA module to be able to use it in the worksheet.
Function Eval(range)
Dim r
r = Evaluate("=" & range)
Eval = r
End Function
However, I've updated the workbook you attached with this function, so please find it below.
Regards,
Haytham
Thank you very much, Haytham! I appreciate you sending me the updated workbook so I could see your code in action.
Ronna
