Making all references in a range absolute
 

Hi

I have a lot of If formulas in a sheet.
Now I need to have all the cellreferences in the sheet(D16:J51) made
absolute...
I have tried copy/drag but apparantly the formulas are too complicated
for Excel to copy/drag them.

Any ideas?

I'm guessing this cannot be done without a macro, but if that what it
takes...

Making all references in a range absolute
 

Okay

Found an answer to this in another older thread

Sub SetAllToAbsolute()

Dim c As Range

For Each c In Selection '<--Cell became C

If c.HasFormula Then

c.Formula = Application.ConvertFormula(c.Formula, _

xlA1, xlA1, xlAbsolute)

End If

Next c '<-- I like it here, too <bg

End Sub

By Don Guillett