Changing text of Target.Adress using replace in VBA

Hi All,

see code:

Please Login or Register  to view this content.

Basically, say my range that is selected (or Target.Address) is "$D$46:$E$48, $D$50:$E$50" , and obviously the macro only really runs when there is a change in "E", what i want my macro to do is change what ever is between the $ signs to "G" and i've tried using the replace method, but that doesnt seem to work.

Could some one please help.

Thank you

Claudio