title: Is it possible to sort formula results?
body: <p>i have sheet with formulas which results depending on multiple columns, where each data row contains attributes of some measurement. And i need to sort formula results.</p>
  
  <p>When i try something like this, it sorts nothing. I even thought about sorting source data, but i need to sort them by formula result... </p>
  
  <pre><code>Sub formulaSort()
      Dim testSheet As Worksheet
      Set testSheet = Sheets("Sheet1")
  
      With testSheet
          .Range(.Cells(2, 4), .Cells(18, 4)).Sort key1:=.Range("D2"), order1:=xlAscending
  
  
      End With
  
  End Sub
  </code></pre>
  
  <p>So is here some option how to sort formula results, or multiple data columns by formula result?</p>