Need to add a column to a sheet without messing up all the coding

edit

Is there a way to automatically reorganize a macro code so that when new columns are added to the sheet it will add the equivalent number to the positions specified previously?

No.

There are several ways to go about referencing specific sections of a sheet. When you "hardcode" by column number, a find/replace might work. I would never use that in macro code. Too many ways for it to go terribly wrong.

The best general advice I can give you is to separate processing from presentation. If you need to add a column to the processing part, append it to your table (use the first available column outside your current dataset). Presentation can be made through direct references or some extraction technique (filters, pivot table).

If you can share the macro(s) with us and explain what it does (desired result, not inner workings), we may be able to advise on adjusting your code. From what you have given, it is impossible to provide any specific advice.

For the actual question you posed:
Automated code generators exist. They will adjust the generated code according to set parameters. To my knowledge, generalized "code fixing" automata to adjust variable references do not exist. You have to do it yourself.

So the simple answer to your simple question is: "No"