how to sort negative and positive values ?

[Dimster]

I don't suppose a Select Case would work here?

Select Case Value

  Case =>0 
   Sort Assending Order

  Case <0
   Sort Decending Order

End Select