Peter Chan
asked on
Problem with Sort
Hi,
Having run these
Having run these
With Worksheets("Sheet9").Sort
With .SortFields
.Clear
.Add Key:=Range("B1:B1") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
End With
.SetRange Range("A:D")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
only the highlighted row is not in proper position (as shown below). Why?
Look for a leading space.
ASKER
There is no leading space within cell B2.
ASKER
Sorry, it should be Cell B1.
ASKER
Which is the 2nd cell, being highlighted in above.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.