microsoft excel course - Sort column data

Resolved · Low Priority · Version Standard

Sort column data

Yogesh has attended:
No courses

by - delegate Yogesh [1 post] (2007 Dec 21 Fri, 09:31) Reply

I want the excel vba statement to sort the data in a column.
I have tried the statement: -
Range("A1").SortSpecial SortOrder = x1Ascending

But now its not working. I get the compile error. Cant find project or library?

Also i dont know which library files are need to be installed.

Please give me the alternate statement for this?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Sort column data

by - trainer Katie gold contributer [214 posts] (2008 Jan 2 Wed, 09:59) Reply

Hi Yogesh,

Thank you for your question.

Range("A1").SortSpecial will sort on the cell A1 only.

1) If the range region is fixed, then type in the region:
e.g. Range("A1:D40").Sort

2) If the range region is flexible, then type in the selection:
e.g.
Selection.CurrentRegion.Select
Selection.Sort Key1:=Range("A1")

3) To sort data by first column in ascending order, I would use the following 2 lines:
Selection.CurrentRegion.Select
Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, _
Header:=xlGuess, OrderCustom:=1

Hope this helps.

Regards,
Katie