@Winon

For some reason the attachment option is not working for me.

What I am trying to do here is automatically substitute symbols for specific text. That VBA code was provided in a previous post, but I want this VBA to only effect a range of cells "D9:D49" for example.