| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting text to formulas
I am trying to streamline a mathematical optimization program that I wrote in
Excel with a macro. Say that I have typed a formula into cell A1 as a text string, such as "x^2+10*x^4". Next I have renamed cell B5 as "x". I want the cell C5 to convert the formula written as a text in A1 to the formula "=x^2 +10*x^4" which will reference cell B5 and calculate it without having to manually copy in the equation from A1. I tried the Visual Basic Range.Formula= function but this only returns a text. Substitute() and Text() do not seem to work either. Does anyone know how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| How to identify text from a autofiltered list using formulas | Excel Worksheet Functions | |||
| need a refresher: text boxes on charts that use relational formulas? | Charts and Charting in Excel | |||
| show text after formulas | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Threaded Mode
