Thread
:
Autofilter sorting.
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Autofilter sorting.
Have you tried sorting first and then filtering.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"LaDdIe" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett