Hi

if you use absolute referencing the formula should not change, e.g. use
=SUM($A$1:$A$100)
instead of
=SUM(A1:A100)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Kinjalip" wrote in message
...
Is there a way to copy a formula from one cell to another cell to get the
same answer. When attempting to copy a formula from one cell to another,
the
column and row destinations are changing in the formula, with a result of
0
not he original solution.
Thanks
--
Jeffrey L. Lippard, A+ certified, CHDP certified