macro adding formula to new sheet

T

toddsavage100

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
 
P

Paul Lautman

toddsavage100 said:
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
Click to expand...

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?
 
D

David McRitchie

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
--
 
Top