You want an absolute address. Precede the cell you want to stay constant
with a $ sign. That tells Excel not to change it. Or, if you want, F4 will
do it for you.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"keithpt" wrote in message
...
I want to make a formula that when dragged will have one variable that will
change as it comes down the page and one that will stay constantly
refering
to a given cell.