Selecting the 5 highest values

Hello,
Can someone pls help me on excel

I am trying to select top 5 values from a range of numbers. What macro should I use so that excel figures out the 5 maximum numbers from the range of values. I know its easy to extract the highest value by using MAX(Range) formula but that only gives one value. how can we get 5 highest values

Thanks