Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy VBA question
I want to save a cell's formula for later replacement after I temporarily change the cell content in the macro. I can't figure out how to save a formula to a var. I can save the value just fine, but that's not what I want. I know this is basic, but it's eluding me. -- dman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy VBA question
try:
strFormula = Range("A1").Formula "Dallman Ross" wrote: I want to save a cell's formula for later replacement after I temporarily change the cell content in the macro. I can't figure out how to save a formula to a var. I can save the value just fine, but that's not what I want. I know this is basic, but it's eluding me. -- dman |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy VBA question
where strFormula is dimmed as a string.
"Dallman Ross" wrote: I want to save a cell's formula for later replacement after I temporarily change the cell content in the macro. I can't figure out how to save a formula to a var. I can save the value just fine, but that's not what I want. I know this is basic, but it's eluding me. -- dman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy Question | Excel Worksheet Functions | |||
If - easy question | Excel Discussion (Misc queries) | |||
*EASY* question! | New Users to Excel | |||
new user with easy question? not easy for me | New Users to Excel | |||
easy question | Excel Worksheet Functions |