JimS
02-25-2009, 01:28 PM
I'm using the following VBA to Sort on Column - A and then Column - B.
Range("OT").Select
Selection.Sort Key1:=Range("A10"), Order1:=1, Key2:=Range("B10"), _
Order2:=1, Header:=1, OrderCustom:=1, MatchCase:=0, _
Orientation:=1, DataOption1:=1, DataOption2:=0
Can it be modified to Sort on Column - A and then only use the first 7 charaters of Column - B.
Thanks for any and all help.
Jim
Range("OT").Select
Selection.Sort Key1:=Range("A10"), Order1:=1, Key2:=Range("B10"), _
Order2:=1, Header:=1, OrderCustom:=1, MatchCase:=0, _
Orientation:=1, DataOption1:=1, DataOption2:=0
Can it be modified to Sort on Column - A and then only use the first 7 charaters of Column - B.
Thanks for any and all help.
Jim