change a long column of references from relative to absolute
Need a macro.
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
Gord Dibben MS Excel MVP
On Wed, 17 Jan 2007 12:35:00 -0800, ams228
wrote:
How do I change a long column of references from "relative" to "absolute"
within formulas when it is too time consuming to change each one
individually.
|