Presume you mean lowest to highest? For range in column A

Range("A1:A500").Sort Key1:=Range("A1"), Order1:=xlAscending

Cheers
Nigel

"Andrew" wrote in message
...
if i have a page of random specific numbers, how do i get
the macros (on excel) to choose specific numbers and also
put them in order for largest to highest?