Lock all cell refferences i.e. add $

[bofonomo]

I want to find a way of locking all cell references in a LOT of formulas at once. Basically if for example there is a reference to A10, I want to turn it into $A$10.

This is so I can copy and paste a table without the cell references "moving" with it.

I hope I am clear in want I want to do. Any Ideas or Pointers?

Kind regards

 

[Datsmart]

This code will convert all formulas to Absolute on the active worksheet.

Sub MakeAbsolute()
Set Rng = ActiveSheet.UsedRange
    For Each c In Rng.SpecialCells(xlCellTypeFormulas)
        c.Formula = Application.ConvertFormula(c.Formula, xlA1, , xlAbsolute)
    Next c
End Sub

 

[bofonomo]

Nice! Thank you very much!