Hi, I wanted to add codes that can sort blanks to bottom of list to my specific set of codes. Below are the codes :
Sub Rectangle5_Click()
'
' Rectangle5_Click Macro
'
'
Range("A4").Select
ActiveWorkbook.Worksheets("5 Column").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("5 Column").Sort.SortFields.Add Key:=Range( _
"B5:B1005"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
ActiveWorkbook.Worksheets("5 Column").Sort.SortFields.Add Key:=Range( _
"C5:C1005"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("5 Column").Sort
.SetRange Range("A4:P1005")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub
Im a newbie at vba and I record the macro, so I dont really know what I'm doing. If anyone could be kindly insert codes or modify the codes above I would be very thankful.
Bookmarks