Converting Cell References Rel<>Abs ?

  • Thread starter Thread starter blewyn
  • Start date Start date
B

blewyn

Is it possible to select a range of cells and convert all their
references from relative to absolute, without having to type a $ in
the right places in each and every one ?

Cheers,

Blewyn
 
Blewyn,

You can use a macro to convert the formulas.

Sub ConvertFormulas()
Dim Rng As Range
On Error GoTo EndProc:
For Each Rng In Range("A1:A10").SpecialCells(xlCellTypeFormulas)
If Rng.HasArray = True Then
Rng.FormulaArray = Application.ConvertFormula(Rng.Formula, _
xlA1, xlA1, True)
Else
Rng.Formula = Application.ConvertFormula(Rng.Formula, _
xlA1, xlA1, True)
End If
Next Rng
EndProc:
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top