Absolute formulas
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)
|