On Thu, 6 Aug 2009 11:41:41 -0700 (PDT), jason wrote:

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.

Without your posting your code, I would think that

cells(1,2).value = cells(1,1).value + 1

should work.
--ron