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