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