Is there a possibility to lock all cell references in a range without knowing the cell contents? For example, I have three cells:
A1 = 3*B1/D$3
A2 = $C4
A3 = 125

I would like my macro to change them:
A1 = 3*$B$1/$D$3
A2 = $C$4
A3 = 125

The problem is that I don't what formulas or values the cells contain or if they are even just empty cells. I just know the range that requires the action.