Jon, Copy cells H6:H7, then select H6:H299 and pastespecial formulas. Just make sure your formula is =H6*$H$3 HTH, Bernie MS Excel MVP "jon104" <jon104@discussions.microsoft.com> wrote in message news:DDAB488A-5CDA-47A2-AD99-A0547A160E8B@microsoft.com... > in cell reference H5 i have a formula H4*H3, I have copied this formula > through to DG5. In cell reference H7 I have a formula H6*H3 which i have also > copied through to DG7.I have formulas right down to cell reference H299 > (H298*H3) Is there a quick way to repeat the copy bearing in mind the cell > references are not together ie H5, H7, H9 and so on.

0 |

1/9/2006 3:25:44 PM