Data validation by column headings

[calmxy]

Hi, I would like to ask how to create code that will generate an error message for duplicate table heading names (by column) in VBA, but if I duplicates then it runs the rest of the code to generate the relevant values.

 

[iliace]

Because it runs already generated relevant values, you will not see the runs of the rest of the code. The code runs of the rest only because the trigger to no other code be drawn and specific, until running of the values in VBA, where it is applicable. Please see the help file for the rest. Don't forget the table headings, they are truly important.