| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract formula result form cell without running formula again
On Aug 6, 2:40*pm, jason wrote:
hello, i have a routine that outputs a very long routing into a cell. i want to then take this result and make use of it in another calculation. how can i take the resulting value without executing the entire function again? thanks! ** in vba. so basically cells(1,1)=routine() cells(1,2)=cells(1,1) +1 (for example) i tried .value and .evaluate with no luck. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
| extract formula result form cell without running formula again | Excel Programming | |||
| cells show formula like in formula bar, rather than result of form | Excel Discussion (Misc queries) | |||
| Using the result of formula as part of reference to a cell in form | Excel Worksheet Functions | |||
| Using the result of a cell's formula as an argument within a running macro? / More | Excel Programming | |||
Threaded Mode
