| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change values to formulas
I've seen a lot of threads addressing changing formulas to values, but
haven't come across one going the other way. I have a spreadsheet that gets created with all values. Column E is the sum of columns C and D. I'm trying to figure out the code that will go through column E, and at every occurance of a number, replace that number with the formula =C+D. I tried using Isnumeric as a test, but it plugged that formula into all the blank cells as well. If IsNumeric(ActiveCell.Value) Then ActiveCell.FormulaR1C1 = "=RC[-2]+RC[-1]" Suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas aren't updating when values change | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Change formulas into values based on cell color | Excel Programming | |||
| Formulas not recalculating when values change on another sheet | Excel Worksheet Functions | |||
| is there a way to change formulas to values for sorting purposes? | Excel Worksheet Functions | |||
Threaded Mode
