software

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 quot;sheet1!quot; 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
img379.imageshack.us/img379/5088/sheet13zc.jpg
img379.imageshack.us/img379/2613/sheet28vd.jpg--
toddsavage100
------------------------------------------------------------------------
toddsavage100's Profile: www.excelforum.com/member.php...oamp;userid=32416
View this thread: www.excelforum.com/showthread...hreadid=521939toddsavage100 wrote:
gt; hi i have created a macro which moves one of my formulas to sheet 2
gt; but when i use the macro the formula is moved to sheet 2 but the
gt; value is 0 this is the formula i want moved to sheet 2
gt; =SUM($H$33,$G$576,$D$582) i would put quot;sheet1!quot; in front of each cell
gt; but then each time the value in sheet 1 changes, the value in sheet 2
gt; changes as well and i do not want this to happen. here are some
gt; screen shots of my problem please help me someone i need it done for
gt; tomorow pleaseeeeeee thanks.
gt;
gt; screenshots
gt; img379.imageshack.us/img379/5088/sheet13zc.jpg
gt; 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?
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Paul Lautmanquot; gt; wrote in message ...
gt; toddsavage100 wrote:
gt; gt; hi i have created a macro which moves one of my formulas to sheet 2
gt; gt; but when i use the macro the formula is moved to sheet 2 but the
gt; gt; value is 0 this is the formula i want moved to sheet 2
gt; gt; =SUM($H$33,$G$576,$D$582) i would put quot;sheet1!quot; in front of each cell
gt; gt; but then each time the value in sheet 1 changes, the value in sheet 2
gt; gt; changes as well and i do not want this to happen. here are some
gt; gt; screen shots of my problem please help me someone i need it done for
gt; gt; tomorow pleaseeeeeee thanks.
gt; gt;
gt; gt; screenshots
gt; gt; img379.imageshack.us/img379/5088/sheet13zc.jpg
gt; gt; img379.imageshack.us/img379/2613/sheet28vd.jpg
gt;
gt; The screen shots are too small to be of any use.
gt;
gt; Maybe the target cells for the formula cause it to be zero?
gt;
gt; Maybe it would help if you posted the macro and what the formula looks like
gt; after the move?
gt;
gt;