I have a macro which contains a formula which creates a number in a cell. I
want to use that result in a formula in another cell. How do I save the
result from the first cell so that I can use it in a second cell. The
relative locations of the two cells may vary from spreadsheet to spreadsheet
but I know how to activate each cell.

=A1


--
Regards
Dave Hawley
www.ozgrid.com
"msdrolf" wrote in message
...
I have a macro which contains a formula which creates a number in a cell.
I
want to use that result in a formula in another cell. How do I save the
result from the first cell so that I can use it in a second cell. The
relative locations of the two cells may vary from spreadsheet to
spreadsheet
but I know how to activate each cell.