Copying the cell contents(a math function) that calculates a numbe
 

Copying the "cell contents" (a math function) that calculates a number to
anouther cell. I can copy the result of the calculation but I need to display
the equation in an ajoining cell for verification of the equation. All I can
do is display the result.

I am working in excel 2000, unfortunatly
I am using the VBA in excel for ease of use.
Later I guess, I would like to use VB.net

I dont know where else to look.

Thank You,
David

Copying the cell contents(a math function) that calculates a numbe
 

activeCell.offset(0,1).Value = "'" & activeCell.formula

--
Regards,
Tom Ogilvy


"DMB" wrote in message
...
Copying the "cell contents" (a math function) that calculates a number to
anouther cell. I can copy the result of the calculation but I need to
display
the equation in an ajoining cell for verification of the equation. All I
can
do is display the result.

I am working in excel 2000, unfortunatly
I am using the VBA in excel for ease of use.
Later I guess, I would like to use VB.net

I dont know where else to look.

Thank You,
David