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?