I am not a professional programmer but every now and then I am required to create macros to perform complex actions in worksheets. For that I go online to study specifically what I need and frequently adapt codes I find. Now I was asked to add a column to a sheet that has a very long code (made by myself with the above mentioned technique which relies on the existing column numbers to work. I imagine programmers face this situation on a daily basis so I am hopeful I will get help here
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?
Thanks in advance.