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?