Move code references over two columns

[ttianna]

I have some VB code and a macro. I need to have all the code in both move over two columns. This is because it's based on a template that I need to add two columns to. So, what used to be column A is now C, B is D, etc. I'm sure there is a way to do this without combing through all the code and manually moving every cell reference, I just don't know how to do it. Thanks!

 

[JackDanIce]

If you post your code, be easier to suggest an answer

 

[ukmikeb]

Hi

If your range references in the code are like Range("C2")....

Then try a Find ") and Replace with ").Offset(,2)

hth