title: VBA Sort method of Range class failed
body: <p>I know there are several threads on this topic but none of the answers have helped resolved this error. </p>
  
  <p>I am trying to sort a table using three keys but receive the error, "Run-time error '1004': Sort method of Range class failed"</p>
  
  <p>I've tried changing "Range("L2")" to ".Range("L2")" and received the error, "Compile error: Invalid or unqualified reference"</p>
  
  <p>I've tried specifying the actual range instead of using columns, I've removed the last two keys and tried just the first, still received the run-time error.  </p>
  
  <pre><code>shtData.Activate
  
  shtData.Range(Range("A2"), Range("Z8000").End(xlUp)).Sort _
  Key1:=Range("L2"), Order1:=xlAscending, _
  Key2:=Range("M2"), Order2:=xlAscending, _
  Key3:=Range("B2"), Order3:=xlAscending, _
  Header:=xlYes
  </code></pre>
  
  <p>If you have any suggestions, I'd greatly appreciate it. I had this working yesterday and my excel crashed and did not recover the changes I made, I cannot figure out why I can't get it to work today. </p>