hi,
Want to sort worksheet without selection,
code below dosent work,
get error "Object do not support property or method"
Want to sort worksheet without selection,
code below dosent work,
get error "Object do not support property or method"
VBA Code:
With Worksheets("Sheet1")
.SortFields.Add Key:=Range("B1"), Order:=xlAscending
.SortFields.Add Key:=Range("A1"), Order:=xlAscending
.SetRange Range("A1:AO" & lastrow)
.Header = xlYes
.Apply
End With