Sorting rows by alphabetizing column E

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Sorting rows by alphabetizing column E

Post by ABabeNChrist »

How to sort rows 3:855 by alphabetizing column E

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sorting rows by alphabetizing column E

Post by HansV »

Manually or using VBA?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Sorting rows by alphabetizing column E

Post by ABabeNChrist »

vba

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sorting rows by alphabetizing column E

Post by HansV »

If you want to sort row 3 with the rest of the rows:

Code: Select all

    Range("3:855").Sort Key1:=Range("E1"), Header:=xlNo
If row 3 contains headers that should not be moved, change xlNo to xlYes.
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Sorting rows by alphabetizing column E

Post by ABabeNChrist »

Works great thank you Hans