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.

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.