Copy and Paste 'Formula'

[rogersj]

I want to copy some cells, like this one:

=SUMPRODUCT((Passthru!A1:Passthru!A992>=B2)*(Passthru!A1:Passthru!A992<=B3))

And paste the Forumla only 1 cell to the right. But when I paste or Paste Special>Formula, A's becomes B's and B's become C's.

How can I do this?

 

[lenze]

You need to change your cell references to Absolute as opposed to relative. See help file for absolute and relative cell references.

Also, If you don't want to change your formulas, you can just move the cells. This will keep you forumlas in tact.

 

[rogersj]

Thanks for the info, its working fine now.