retaining referenced cell when inserting column

Hi There,

I want to be able to retain the referenced cell in a formula when I insert a column.

for example.

I have the following formula

=power((1+c4)*(1+d4)*(1+e4),12/12)-1

If I insert a column at colum C the formula changes to

=power((1+d4)*(1+e4)*(1+f4),12/12)-1

I want to be able to retain the original formula without having to rewrite the formula. Is there an absolute function I can use or something along those lines.

I hope this makes sense.

Cheers,

Easty

add a dollar sign in the cell references for eg. instead of C4 make in $C$4

Maybe this,

=POWER((1+INDEX(1:1048576,4,3))*(1+INDEX(1:1048576,4,4))*(1+INDEX(1:1048576,4,5)),12/12)-1

Change 1048576 by 65536 if files is saved as a 2003.

Regards

to Roshan and Sailepaty,

Thanks so much for your assistance.

Roshan unfortunately your suggestion doesn't work......thanks anyway.

Saitepaty, yours works perfectly......your're a legend!!!

Cheers

Easty