Adding Column after checking if the value exists or not

Hi experts,

I have a data ranging from Column A to Column BX.

I am trying to insert a column M (which already has a data) and put the value "Gross Sales" in M4. The VBA code that I have created, however, adds the column all the time since the code is run for multiple times for updating other operations. I have the following code and want to put a check event which checks Column M if value "Gross Sales" is available or not. If it is available do nothing and if it is not then add Column M and set "Gross Sales" in Cell M4. I appreciate for codes that will stop addition if the value "Gross Sales" exist in Column M.

Please Login or Register  to view this content.

Thank you
Roshan Shakya

Please Login or Register  to view this content.

Originally Posted by Roshan.Shakya

Thank you JLGWhiz.

You're welcome,
regards, JLG