Excel 2007 :: VLookup Formula With Indirect Function

Code:
=D5-VLOOKUP($C5,$C$45:$F$80,2,0)

I have formulas such as above in my Worksheet. So the above is in Cell H5

For the Range $C$45:$F$80, I am inserting rows (So moving down the data) and copying data from $C$5:$F$40 as values into the new space in $C$45:$F$80

I am doing the above using a macro, but when I run it I want this

Code:
=D5-VLOOKUP($C5,$C$45:$F$80,2,0)
to stay static, but instead I end up with

[CODE=D5-VLOOKUP($C5,$C$85:$F$120,2,0)[/CODE]

So my Table Array $C$45:$F$80 changes to $C$85:$F$120

How can I keep it as $C$45:$F$80

The other references in the formula seem to stay as I want them.