Sorting a column

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Sorting a column

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

December 10th, 2007, 09:47 AM

yogeshyl

yogeshyl is offline

Authorized User

Join Date: Apr 2007

Posts: 41

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Sorting a column

I've made a vba macro file in which i am getting a compile error. I need a code to sort the column or a range of cells. The statement is as follows:-

Range("A1").SortSpecial SortOrder:=x1Ascending

Yogesh

__________________
Yogesh

Old

December 10th, 2007, 07:09 PM

allenm

allenm is offline

Friend of Wrox

Join Date: Feb 2007

Posts: 163

Thanks: 0

Thanked 2 Times in 2 Posts

Default

There is a problem in the above statement. You need l as in L not the number one:
SortOrder=xlAscending

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sorting on date column in XSLT	Palwi	XSLT	1	March 18th, 2008 07:19 AM
Dynamic column sorting	victorcorey	XSLT	1	October 31st, 2007 05:40 PM
Column Sorting/Formatting in MS Datagrid!	ao7711	C#	1	July 13th, 2006 02:32 PM
Sorting lists by clicking column labels	isme	XSLT	0	March 15th, 2006 04:40 PM
sorting a column alphabetically	Adam H-W	SQL Server 2000	8	November 11th, 2003 09:29 AM