Hi Guy's I can't seem to get this one right!!!
I am trying arrange column E2 to intLastRow Ascending
What is the best method please ?
This is the row i am trying to sort A-Z Ascending so the OrgQty (Original Qty) is from Row2 to intLastRow
The OrgQty Column looks like this
Code:
With xlWB .Worksheets(1).Cells(intLR + 1, 1) = Me.StartQty
.Worksheets(1).Cells(intLR + 1, 2) = Me.LiftType
.Worksheets(1).Cells(intLR + 1, 3) = Me.LiftNo
.Worksheets(1).Cells(intLR + 1, 4) = Me.PONumber
.Worksheets(1).Cells(intLR + 1, 5) = Me.OrgQty
TRIED ADDING THIS LINE BUT NO GO!!! .Worksheets(1).Range("E2:" & intLR).Sort Key1:=Range("E5"), Order1:=xlAscending, Header:=xlNo
.Worksheets(1).Cells.EntireColumn.HorizontalAlignment = xlLeft