LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default how can I sort on the column selected by the user?

I query the user via a userform to select the heading (column) they want to
sort on. The userform returns a column. I need to sort everything from row
11 down based on the column selected. I have no problem selecting the cells
from A11 to the end, but I don't know the code to perform the sort. Will
somebody please help?

this is my code for the selecting the range that needs to be sorted
x = Range("A" & Rows.Count).End(xlUp).Row
Range("A11", "AA" & x).Select

If the user selects "ORDER NUMBER" from the user form (column y), how do I
sort my range on column y?
-JEFF-

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sort a column of Randomly selected numbers? Khoshravan Excel Worksheet Functions 8 July 14th 07 08:16 PM
How to sort on the row selected by user? -JEFF-[_2_] Excel Programming 0 September 21st 05 07:36 PM
Opening a user selected workbook David Hall[_5_] Excel Programming 2 January 6th 05 07:56 PM
Get user selected range into RefEdit J. Hall Excel Programming 2 April 9th 04 05:05 PM
How to find out what the user selected? Mike[_31_] Excel Programming 0 July 24th 03 11:02 AM


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"