title: VBA Sorting Blank Cells to Bottom
body: <p>I want to remowe some duplicate Value from an excel Column, but before that I need to sort it right so it dont Remowe any contatn i want to have. The problem i got are the blank cells, i want them to be remowed but they keep staying at any sorting on the top. Here is my sorting code, any Idea?</p>
  
  <pre><code>ABC.Range("A1", "AF" &amp; lngLastRow).Sort key1:=ABC.Range("A1:A" &amp; lngLastRow), _
     order1:=xlDescending, key2:=ABC.Range("P1:P" &amp; lngLastRow), _
     order2:=xlDescending, MatchCase:=False, Orientation:=xlTopToBottom, Header:=xlNo
  </code></pre>
  
  <p>I need a Solution where I can sort them (Blanks) to the bottom with the second key. I DON'T need a solution where i delete them because some of the duplicates have only blank values in this column and I still need to keep them if they dont have any alternativ.</p>