Thread: CODE TO SORT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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
Reply With QuoteReply With Quote