Change an number of cell references from relative to absolute

[makku]

I would like to change a range of cell references from relative to absolute. I would like to perform this change at one go (for eg. via Find & Replave).

What i need to do is for e.g. i want to change:

A B C
1 =C3+C5 =C2+C9 =C10+C12
2 =D3+D5 =D2+D9 =D10+D12


TO:

A B C
1 =$C$3+$C$5 =$C$2+$C$9 =$C$10+$C$12
2 =$D$3+$D$5 =$D$2+$D$9 =$D$10+$D$12


Any ideas?


regards,

[teylyn]

This post has some VBA and links to other sources for what you want to do.