Hi all,
I am using this code to convert formulas from relative to absolute :
I would like to convert only part of the formula e.g.
CS5*J68 to $CS$5*J68
and also how can I convert only columns e.g.
CS5*J68 to $CS5*J68
thanks
A.
I am using this code to convert formulas from relative to absolute :
Code:
Sub lockref()
Application.Calculation = xlCalculationManual
Dim c As Range
For Each c In Selection
c.Formula = Application.ConvertFormula(c.Formula, xlA1, , xlAbsolute)
Next
End SubI would like to convert only part of the formula e.g.
CS5*J68 to $CS$5*J68
and also how can I convert only columns e.g.
CS5*J68 to $CS5*J68
thanks
A.
