ExcelBanter - CODE TO SORT

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - CODE TO SORT (https://www.excelbanter.com/excel-programming/433784-code-sort.html)

Faraz A. Qureshi

CODE TO SORT

What code could sort the CURRENT selection (which may be of any size) on the
basis of the ACTIVE cell?

--
Best Regards,

Faraz

Jacob Skaria

CODE TO SORT

Do you mean?

Selection.Sort Key1:=ActiveCell, Order1:=xlAscending

If this post helps click Yes
---------------
Jacob Skaria

"Faraz A. Qureshi" wrote:

What code could sort the CURRENT selection (which may be of any size) on the
basis of the ACTIVE cell?

--
Best Regards,

Faraz

Faraz A. Qureshi

CODE TO SORT

Unbelievably Excellent Buddy!
--
Best Regards,

Faraz

"Jacob Skaria" wrote:

Do you mean?

Selection.Sort Key1:=ActiveCell, Order1:=xlAscending

If this post helps click Yes
---------------
Jacob Skaria

"Faraz A. Qureshi" wrote:

What code could sort the CURRENT selection (which may be of any size) on the
basis of the ACTIVE cell?

--
Best Regards,

Faraz

All times are GMT +1. The time now is 10:19 AM.