title: VBA Macro to Scan Header Row and Alter Column Data Types
body: <p>I frequently paste data from my SSMS query results into Excel to then analyze the data further from there.</p>
  
  <p>When pasting datetime stamps into Excel, the format comes through pretty messy. I constantly find myself changing these columns to the ShortDate data type.</p>
  
  <p>What I am trying to accomplish is to write a macro that scans row 1 for any header like '%Date%' and changes the entire column to the ShortDate data type.</p>
  
  <p>Can anyone point me in a direction to get started? Thanks!</p>