Hi Harold

There's a lot to learn. We all know very little.

You can use in excel 2 reference styles: A1 and R1C1.

In A1 reference style (the one you are using in the formula) you refer to a cell using letters to indicate the column and numbers to indicate the row.

In R1C1 you use numbers for both the column and the row.

Your formula only uses relative addresses. In this case a formula using R1C1 notation does not change when copied.

Example.

You have in B3

=A1+3

You copy it to B4 and you have

=A2+3

Now copy the formula to C4, you have

=B2+3

Although all 3 formulas mean the same: "cell 2 rows up and one column left +3", due to the A1 notation it is always changing, both the row and the column.

Now in R1C1 reference style, if in cell R3C2 (B3) you write the equivalent to (=A1+3)

=R[-2]C[-1]+3

In this notation if you copy it down or right it will not change because it does not depend on the cell that you enter it. It always means: "cell 2 rows up and one column left +3"

So what I meant was: turn R1C1 reference style on, in Tools>Options>General and then, since the formula is always the same you can select the worksheets and use Find/Replace.

You just need to use the command once if you select all the sheets where the formula is.

I hope it was clear.

PGC