Simplified version of my problem:
I have formulas in cells in A1 through A6 as follows:
A1 =B1/B11
A2 =B2/B11
A3 =B3/B11
A4 =B4/B11
A5 =B5/B11
A6 =B6/B11

I can't change the B11 to $B$11 or B$11 (it's a long story). I have a macro
that inserts rows in the above range, say between A3 and A4. The macro
copies the formula from A3 to A4, but returns the relative formula =B4/B13.
The B4 is correct, I want that relative, but I want the B13 to be B12 in the
newly inserted row. How do I copy that part of the formula absolutely?