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.

To expand on what I just wrote, whether you can do this or not may depend on
information you have not shared with us.

For example, if you are trying to do this as part of a VBA Function, it will
not work as a function can only output a value. I have assumed you have done
this as part of a macro (Sub) since I have assumed that a "very long routing"
means some kind of formula that you have placed into cells(1,1).

That being the case, there may be more efficient ways of solving your entire
problem.
--ron