macro adding formula to new sheet

[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

[Paul Lautman]

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?

[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
--
---
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" <[email protected]> wrote in message news:[email protected]...
> 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?
>
>