Changing all Formulas to Absolute References

  • Thread starter Thread starter Arska
  • Start date Start date
A

Arska

Hi

Is there a way to change all the existing formulas in a workbook to
Absolute cell references?

Thanks

-A
 
Is there a way to change all the existing formulas in a workbook to
Absolute cell references?
Click to expand...

Using a macro, yes.


Sub foo()
Dim ws As Worksheet, c As Range

For Each ws in ActiveWorkbook.Worksheets

For Each c In ws.UsedRange

If c.HasFormula Then _
c.Formula = Application.ConvertFormula(c.Formula, xlA1, , xlAbsolute)

Next c

Next ws

End Sub
 
Back
Top