Greetings,
I have a 17 column data area with autofilter on columns 14 & 15. I want to
make it easy for the novice user to do a custom filter on col 15 with the
following recorded code form a macro button:
Selection.AutoFilter Field:=2, Criteria1:="=04/01/2006", Operator:=xlAnd
This works but I suspect it needs tidying up?
Also, how can I code to ensure that the user is always initially looking at
the top of the filtered list (Ctrl + home would do it from the keyboard)
rather than being scrolled part way down?
Many Thanks