How to turn a string formula into a “real” formula?

by

Evaluate might suit:

http://www.mrexcel.com/forum/showthread.php?t=62067

Function Eval(Ref As String)
    Application.Volatile
    Eval = Evaluate(Ref)
End Function

More Related Contents:

  1. Calculation is wrong, Rounding wrong
  2. Last non-empty cell in a column
  3. Excel formula to get cell color [duplicate]
  4. Call a Sub with a String
  5. Count Unique values with a condition
  6. Rounding in MS Access
  7. How can I run VBA code each time a cell gets its value changed by a formula?
  8. Concatenate column headers if value in rows below is non-blank
  9. Fill formula down till last row in column
  10. Optimizing Excel formulas – SUMPRODUCT vs SUMIFS/COUNTIFS
  11. Unicode string literals in VBA
  12. Fill non-contiguous blank cells with the value from the cell above the first blank
  13. Excel Reference To Current Cell
  14. How to extract text within a string of text
  15. Get parent folder path from file path using cell formula
  16. Why does Range.BorderAround emit “True” to the console?
  17. In Excel VBA, how do I save / restore a user-defined filter?
  18. Using VBA in Excel to Google Search in IE and return the hyperlink of the first result
  19. Excel vba refresh wait
  20. Excel vba to create every possible combination of a Range
  21. reading Excel Open XML is ignoring blank cells
  22. Run a Macro from Another Workbook
  23. Sorting a dictionary by key in VBA
  24. Handle “No cells were found” error when filtered range is empty
  25. Excel: the Incredible Shrinking and Expanding Controls [closed]
  26. Excel: Search for a list of strings within a particular string using array formulas?
  27. Generate Word Documents (in Excel VBA) from a series of Document Templates
  28. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  29. Build a Comma Delimited String
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment