I want to fix (set) a formula in excel by inserting $ in all form.

[Lisa]

Is there a way to change all formulas in an excel worksheet to be fixed. for
example b4 to $b$4 without having to go into each individual formula?

thanks
Lisa

 

[Vasant Nanavati]

You would need to use the following macro from Gord Dibben:

Sub Absolute()
Dim cell As Range
For Each cell In Selection
If cell.HasFormula Then
cell.Formula = Application.ConvertFormula(cell.Formula, _
xlA1, xlA1, xlAbsolute)
End If
Next
End Sub