Sorting rows by alphabetizing column E
-
ABabeNChrist
- SilverLounger
- Posts: 1805
- Joined: 25 Jan 2010, 15:57
- Location: Conroe, Texas
Sorting rows by alphabetizing column E
How to sort rows 3:855 by alphabetizing column E
When one door of happiness closes, another opens,
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller
-
HansV
- Administrator
- Posts: 73825
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
ABabeNChrist
- SilverLounger
- Posts: 1805
- Joined: 25 Jan 2010, 15:57
- Location: Conroe, Texas
Re: Sorting rows by alphabetizing column E
vba
When one door of happiness closes, another opens,
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller
-
HansV
- Administrator
- Posts: 73825
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sorting rows by alphabetizing column E
If you want to sort row 3 with the rest of the rows:
If row 3 contains headers that should not be moved, change xlNo to xlYes.
Code: Select all
Range("3:855").Sort Key1:=Range("E1"), Header:=xlNo
Regards,
Hans
Hans
-
ABabeNChrist
- SilverLounger
- Posts: 1805
- Joined: 25 Jan 2010, 15:57
- Location: Conroe, Texas
Re: Sorting rows by alphabetizing column E
Works great thank you Hans
When one door of happiness closes, another opens,
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller
but often we look so long at the closed door that we do not see
the one that has been opened for us.
Helen Keller