If you don't want the value to change then why are you copying a formula.
cell is a single cell range as you might use if your were looping through cells
or only working with a single cell.

cell.value is the value
cell.formula is the formula
cell.text is a formatted string of what appears in the cell.
cell.numberformat is the format itself
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Paul Lautman" wrote in message ...
toddsavage100 wrote:
hi i have created a macro which moves one of my formulas to sheet 2
but when i use the macro the formula is moved to sheet 2 but the
value is 0 this is the formula i want moved to sheet 2
=SUM($H$33,$G$576,$D$582) i would put "sheet1!" in front of each cell
but then each time the value in sheet 1 changes, the value in sheet 2
changes as well and i do not want this to happen. here are some
screen shots of my problem please help me someone i need it done for
tomorow pleaseeeeeee thanks.

screenshots
http://img379.imageshack.us/img379/5088/sheet13zc.jpg
http://img379.imageshack.us/img379/2613/sheet28vd.jpg

The screen shots are too small to be of any use.

Maybe the target cells for the formula cause it to be zero?

Maybe it would help if you posted the macro and what the formula looks like
after the move?