Macro to delete column if it contains specific wording

Hi All

Really hoping that someone can help and I think this issue is driving me crazy.

I have designed a Macro that takes a load of raw data and formats in. This works a charm however every now and again an extra column appears called Delivery Priority. This of course throws all the other caluations out. I therefore require some coding that will look at the coloums (It normally is Q but can also appear in others) and delete this. Not sure if this matters however the wording is in row 10

Any ideas?

Hi,

something like this? Loop through row 10 for "Delivery Priority" and delete it when found.

Please Login or Register  to view this content.

Thanks for the reply? This however doesnt seem to work - any ideas why?

The code is looking in all used columns and if row 10 has the word "Delivery Priority" it deletes that column. It should work. When you step over using F8, does it show any error, or it does not delete the column?

Try this one

Please Login or Register  to view this content.