macro coding

A

Andrew

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?
 
N

Nigel

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

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

Cheers
Nigel
 
Top