L
LaDdIe
Hiya
I have 6 columns with autofilter enabled.
I have been able to select autofilter via VBA as follows;
Selection.AutoFilter Field:=6, Criteria1:="TEB"
And all is fine
However I also want to sort column 1 in ascending order,
Selection.AutoFilter Field:=1 Order1:=xlAscending
But I can't get it right!
Can anyone in this forum help
With Thanks
I have 6 columns with autofilter enabled.
I have been able to select autofilter via VBA as follows;
Selection.AutoFilter Field:=6, Criteria1:="TEB"
And all is fine
However I also want to sort column 1 in ascending order,
Selection.AutoFilter Field:=1 Order1:=xlAscending
But I can't get it right!
Can anyone in this forum help
With Thanks