ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro coding (https://www.excelbanter.com/excel-programming/305277-macro-coding.html)

Andrew[_37_]

macro coding
 
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?

Nigel

macro coding
 
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?





All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com