I apologize for I've just realized I had made a mistake when I stated my question.

The correct question was, what can you do whan you add a row above a cell referred to in another cell's formula:

Instead of:

Sheets("MU").Cells(30, 6).Value = "100"

I should have written something like:

Sheets("MU").Cells(30, 6).Value = Sheets("MU").Cells(26, 18).Value

so that when you add a row above row 26 the macro assigns to cell (30,6) the value of cell (26,18) the contents of which has been now pushed to cell (27,18).

All right, don't you guys rack your brains, I came up with the solution already. Just define a variable pointing to the relevant cell.

Can I rate myself up?