title: sort multiples ranges with loop vba
body: <p>I have 65 ranges in colums next to each other. The first range is "D39:D122", the next range is "E39:E122"... the last range is "BP39:BP122". </p>
  
  <p>It's possible that all 65 ranges are filed with data, but it is also possible that only 10 ranges are filled with data.I already managed that if there are 10 ranges filled with data, that it is the first 10 ranges that are filled.</p>
  
  <p>The data: it is a list of maximum 84 different cells (from D39 to D122), sometimes only 15 cells are filled with data, sometimes 24, sometimes nothing.</p>
  
  <p>The question: how can a sort each range in ascending order using a loop. </p>
  
  <p>Example</p>
  
  <pre><code>        D           E           F       etc... BP
  39    ID0077      ID0325     ID0037
  40    ID0134      ID0704     ID0206
  41    ID0001      ID0011     ID0042
  42    ID3481      ID2005     ID0215
  43    ID0280      etc..      ID0005
        etc...                 ID0015
                               ID0328
                               ID0712
                               ID0332
                               ID0713
                               etc...
  </code></pre>
  
  <p>Second question: there is a second and a third range like this:the second range from (D126:D209) till (BP126:BP209), the third range from (D299:D303) till (BP299:303). How can I loop through this? </p>
  
  <p><a href="https://i.stack.imgur.com/zwm1M.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zwm1M.jpg" alt="enter image description here"></a></p>