Make sure that the formula does not have $ signs, e.g. change

=$A$1*17 to

=A17*17

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Loreilor" wrote in message
...
How do I copy and paste a formula that automatically changes its
references
according to its position on the worksheet?