Sorry Gord
Didn't notice the requirement to fix column only.
I should have posted your sets of code in their entirety.

--
Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
For those you would need a macro similar to the one Roger posted but for
Absolute Column only

Sub AbsoluteCol()
Dim Cell As Range
For Each Cell In Selection
If Cell.HasFormula Then
Cell.Formula = Application.ConvertFormula _
(Cell.Formula, xlA1, xlA1, xlRelRowAbsColumn)
Next
End Sub


Gord Dibben MS Excel MVP

On Thu, 23 Oct 2008 04:58:00 -0700, Rockbear
wrote:

and some just =sum($G138/9*12)