Paste Special in Excel 2003

[GK]

I've got 7200 cells in column B containing the formula SIN(Ax), where x=the respective row number (1 to 7200). I now need to duplicate this formula in to rows 1 through 7200 of column C, with a minor addition so that the formula becomes SIN(Ax)*D1, where D1 is a coefficient value located in (obviously) cell D1. Using Paste Special (multiply) for all cells in column C I can only get the value entered into cell D1 to copy over - i.e. the formula becomes SIN(Ax)*3 instead of SIN(Ax)*D1. I NEED TO COPY THE F%$#ING CELL REFERENCE (D1) NOT THE F&^$ING ENTERED VALUE (3 OR WHATEVER).

I cannot sit here and manually type the correct formula into 7200 cells. Someone please help before I headbutt my computer out of the window.
 

[alanb]

try SIN(Ax)*$D$1 and then use normal paste. The '$' converts from a relative reference to an absolute reference.

[peter.mitchell]

Usually when I do stuff like that in excel,  I type say. .. 10 cells,  then smart expand, usually picks up the pattern fine.

[GK]

try SIN(Ax)*$D$1 and then use normal paste. The '$' converts from a relative reference to an absolute reference.

Thank you!