I know that if you f2 on a cell and f4 it will change the formula cell reference to what I call hard code them.

ex. $a$1

I need to know how to write a vba statement to change all whole range.

example

Q5:Q48 has formulas like this =SUM(S18:AD18).
I need them all to be hard coded; like this =SUM($S$18:$AD$18).

Is there a way to write a vba code for this.

Thanks
rlkerr