keep a cell used in a formula constant when pasteing into another.

[Rob]

I know this is simple but I haven't found out how yet.

 

[Gord Dibben]

Rob

Have a look in Help for "about cell and range references" which explains the
difference between Absolute and Relative references.


Gord Dibben Excel MVP