title: "Sort Method of Range Class Failed" -error
body: <p>I have a spreadsheet that does not cooperate with a macro in our excel processor that we send these excel files through. The only way to get it to work is to copy the values only over to a new spreadsheet and adjust the date format manually. Only once it’s in these new spreadsheets can I send it through the excel processor with no hiccups.</p>
  
  <p>I get "Sort Method of Range Class Failed"  when trying to send the excel files through. I'm not much familiar with VB so I'm hoping someone can take a look at the bare-bone excel sheet data and tell me where the problem exists.</p>
  
  <p>Here's a screenshot of the first few entries of the spreadsheet.</p>
  
  <p><a href="https://i.stack.imgur.com/G0exx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/G0exx.png" alt="enter image description here"></a></p>
  
  <p><strong>Update:</strong></p>
  
  <p>Upon debugging the error, the compiler stops at the below line:</p>
  
  <pre><code>Columns("A:H").Sort key1:=Range("H2"), order1:=xlAscending, Header:=xlYes
  </code></pre>
  
  <p>Here's the full code for this section only:</p>
  
  <pre><code>'Sort the rows based on the data in column C
  Range("H1") = "Index"
  Columns("A:H").Sort key1:=Range("H2"), order1:=xlAscending, Header:=xlYes
  Application.ScreenUpdating = True
  'Add big formula
  Range("I2:I" &amp; DataWBLRow) = BigConcat
  Range("J2:J" &amp; DataWBLRow) = FormString3
  </code></pre>