title: VBA-Excel Rearrange columns in alphabetical order when new column is added
body: <p>I´m having issues on my file when adding a new column through VBA. When clicking on a button it gets a process ID number and creates a column on table from a different sheet.</p>
  
  <p>How can I rearrange the columns order alphabetically (By header value) each time a new column is added.</p>
  
  <p>The number of columns is dynamic and I can´t know the header name until the user creates a process.</p>
  
  <p>This is my current code:</p>
  
  <pre><code>'Create a new column on the process assignment table
  Sheets("T_PRAS").ListObjects("T_PRAS").ListColumns.Add.Name = "PR_" &amp; Sheets("Administrador").Range("B53").Value
  </code></pre>