I have a row with very simple formulas in each of 5 adjacent cells. The formulas are of the type =b1, =c1 and so on.

What I want to do is to make all of the formulas absolute references - =$b$1, =$c$1 and so on.

How can I write a macro to do this automatically?

In other words, I want the macro to start at the first cell and change the references to absolute, go to the next cell to the right and change the references to absolute and so on.

The macro recorder doesn't do this correctly.

Can anybody help me out? I'm very new at Excel macros so the simpler the better.

I'm probably dating myself but you could do this very easily in Lotus. I'm hoping there is a similarly straightfoward approach in Excel.

Thanks.