Hi,

Why not try recording the code? Great method for getting the syntax.

--
Regards,

OssieMac


"yogeshyl" wrote:

I need a code to sort a column in a excel file in ascending order. I had used
the below code
Range("A1").SortSpecial SortOrder:=xlAscending

but its giving error. Kindly guide me on this.

Yogesh