Hi All,

I am aware that by highlighting (selecting) a formula (i.e. if A1 is "=A10") and then pressing F4 it makes the formula absolute, i.e. $A$10.

I have over 200 formulas which I need to make absolute but it seems you have to select each formula individually then press F4.

Is there a Vb command that makes formulas absolute?

Thanks

Andi