insert a column without changing the macro

hey all,

I was wondering if i can insert a column after writing the macro.
I tried doing it, but of course, all the cells addresses changed and it was a mess.

thank you in advance for your help.

Ibrahim

You can insert columns when ever you want, but if you have a formula, the cell addresses will change, unless you have absolute reference.

thank you ab33 for your reply,

yes i am using formulas via VBA.
i need to know how to insert and keep the code as is. i absolutely don;t want to go through the code again and change every reference. this can be cruel

Originally Posted by AB33

You can insert columns when ever you want, but if you have a formula, the cell addresses will change, unless you have absolute reference.

Could you please post your code then?