Excel: hold a reference to a single cell when copying formulas?
 

Did you remember to use the $ for both Column and Row?
ie $A$5 vs. $A5
HTH,
--
Gary Brown



"Jim in Texas" wrote:

I used to use '$' signs to keep a refererence to a single cell in a formula
but that doesn't seem to work in the new version. How should I do that?