Evening,

One of the macros I wrote broke today due to the report it pulls from having 2 new columns. For example the macro was looking for the expected data in column "A" but now that data is in column "C". An associate told me he wrote a macro that would check if the data was in the expected columns and if not pop up a message. He didn't recall how he coded it.

Tonight I'm looking for suggestions on how to achieve code i can input into my macro that will check if the headers of certain columns are in the expected places or if those column headers are now called something different. If different pop up a message and exit macro. Thx

Example - macro expects column "A" to have the header "XYZ" & column "K" to have the header "ABC" & column "Z" to have the header "ABCXYZ". If macro doesn't find the expected headers in the expected columns it pops up a message "insert generic message here" and exits the macro.