VBA - Looping through range in descending order : Good morning,

I'm trying to work out a code that would loop through a range in descending order. Basically I would like to start with the maximum value, and on the next loop take the second maximum value, and so on. 

I'm not sure how to go about this, if it could work with a For Each rng in Range sort of way that would be ideal. Any help is appreciated.

Thanks!