How to get part of a macro to perform itself once?

[aemerson2]

I am trying to perform a macro that adds a new column, then put a formula in the columns to find a certain word I am looking for. Everytime I rerun the macro, it inserts a new column, which I dont want to happen. I want the macro to insert a new column, then keep that column to display the results of the formula. Does anyone know how to do this?

[zmbd]

you give absolutely no information as to where or what the current script is performing the action on or with....

basically, if you've inserted the column, then you should be able to check the object for the presence of that column.