Hi All

I am currently writing a visual basic program which will input 100 random numbers into excell. Is there any function that will automatically arange them into ascending order?

Somethign like =SORT(A1:a100)

Anyones input is greatly appriciated.

Regards
Stephen