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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - keep a cell used in a formula constant when pasteing into another. (https://www.excelbanter.com/excel-worksheet-functions/9974-keep-cell-used-formula-constant-when-pasteing-into-another.html)

Rob

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

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

Biff

Hi!

Make the cell references ABSOLUTE:

=SUM($A$1:$A$10)

The $ keeps the column and/or row references from changing.

Biff

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

All times are GMT +1. The time now is 08:43 PM.