Did find one small, stupid mistake on my part.
On the line with the runtime error, I changed what I'd typed as a capital letter I (between H and J) to a lower case L.
That made eliminated the error message, but it still didn't sort the column.
Thanks for helping.
Quote:
Originally Posted by Claus Busch
Hi,
Am Mon, 23 Dec 2013 16:51:30 +0000 schrieb walkingfern:
Yes, Column A is correctly sorted. However, Column B is all awry. I
thought that maybe it had something to do with the sort order of Column
C, so I eliminated that from the "sort by" but it's still out of order.
try following macro for your column B and then try sorting again:
Sub Test()
Dim LRow As Long
Dim rngC As Range
LRow = Cells(Rows.Count, 2).End(xlUp).Row
For Each rngC In Range("B1:B" & LRow)
rngC = WorksheetFunction.Clean(Trim(rngC))
Next
End Sub
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|