Sort a column descending: VBA

**niko79542** · 07-23-2012, 03:58 PM

Hi,

I want to sort column E with descending order.

Here is what I have so far...which sorts it in ascending order.

Worksheets("Sheet1").Range("A1").CurrentRegion.Sort key1:=Worksheets("Sheet1").Range("E1")

**shg** · 07-23-2012, 04:02 PM

Look in Help for range.sort method to see the other arguments.

**niko79542** · 07-23-2012, 04:11 PM

Thx,

Answer:

Worksheets("Sheet1").Range("A1").CurrentRegion.Sort key1:=Worksheets("Sheet1").Range("E1"), Order1:=xlDescending

**shg** · 07-23-2012, 04:16 PM

Help is your friend. Nothing you can read in a forum or a book can replace it.

Re: Sort a column descending: VBA