absolute refernces - range of cells

I am trying to find an easy way to turn a range of cells
from relative references to absolute references without
going into each cell and hitting F4. Any ideas? Thanks

You have to use a macro, press Alt + F11, click insertmodule and paste the
following

Sub ReltoAbs()
Dim Cell As Range
For Each Cell In Selection
Cell.Formula = Application.ConvertFormula(Cell.Formula, xlA1, xlA1,
xlAbsolute)
Next
End Sub

press Alt + Q to close VBE and select the range with formulas and press Alt
+ F8 to run the macro

--

Regards,

Peo Sjoblom

wrote in message
...
I am trying to find an easy way to turn a range of cells
from relative references to absolute references without
going into each cell and hitting F4. Any ideas? Thanks

Thanks!


-----Original Message-----
You have to use a macro, press Alt + F11, click
insertmodule and paste the
following

Sub ReltoAbs()
Dim Cell As Range
For Each Cell In Selection
Cell.Formula = Application.ConvertFormula
(Cell.Formula, xlA1, xlA1,
xlAbsolute)
Next
End Sub

press Alt + Q to close VBE and select the range with
formulas and press Alt
+ F8 to run the macro

--

Regards,

Peo Sjoblom

wrote in message
...
I am trying to find an easy way to turn a range of cells
from relative references to absolute references without
going into each cell and hitting F4. Any ideas? Thanks


.