absolute refernces - range of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 insert>module 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
 
Thanks!

-----Original Message-----
You have to use a macro, press Alt + F11, click insert>module 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




.
Click to expand...
 
Back
Top