RedOctoberKnight
Board Regular
- Joined
- Nov 16, 2015
- Messages
- 150
- Office Version
- 2016
- Platform
- Windows
Good Morning.
I'm racking my brain trying to understand what is going on but I cant seem to figure it out.
I have the following code that I want to sort the range by Last Name in Alphabetical Order.
Last names are in column B starting in cell B7. I have a headers in row 6.
I cant figure out why but every time I run it, I get a different random order in Column B.
Anybody have any suggestions?
I'm racking my brain trying to understand what is going on but I cant seem to figure it out.
I have the following code that I want to sort the range by Last Name in Alphabetical Order.
VBA Code:
Sub sort_CSA()
Range("A6:T74").Sort KEY1:=Range("B6"), order1:=xlAscending, Header:=xlYes
End Sub
Last names are in column B starting in cell B7. I have a headers in row 6.
I cant figure out why but every time I run it, I get a different random order in Column B.
Anybody have any suggestions?