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.