|You can certainly check for the Column Heading within the macro or you can use a Error Handling routine with On Error. With On Error you can force the Macro to stop execution or present a message to the user about the mssing column or basically do whatever you want it to do when an error occurs. You can even test the error value and do different things based on what error occurred. |
Look up the On Error statement in the VBA Help files or via Google. Using error handling routines is very powerful.
If all you want to do is check for the Column heading and exit the macro if the heading isn't found, this is one of the many ways it can be done:
Set c = .Find("MyColumnHeading")
If c Is Nothing Then Exit Sub
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.