Gord Dibben <gorddibbATshawDOTca wrote...
You can copy/paste this routine to a general module in your workbook then
run it on any range you select.

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
....

Tangent: OpenOffice Calc 3.1 can handle this using regular expressions
by replacing

\<([A-Z]+)([0-9]+)\

with

\$$1\$$2

Wouldn't it be nice if Excel provided regular expressions?