Jagwarman
asked on
help on Autofilter
can an Expert help me out with this
I have code that autofilters then does some copying and pasting the first part of the code is
Dim myRange
ActiveSheet.Range("$A:$T") .AutoFilte r Field:=18, Criteria1:="<=15"
then I need to loop this to autofilter on Field 20 but I realise I can't use
ActiveSheet.Range("$A:$T") .AutoFilte r Field:=20, Criteria1:="<=15"
as I get Autofilter method of Range class failed.
Thanks
I have code that autofilters then does some copying and pasting the first part of the code is
Dim myRange
ActiveSheet.Range("$A:$T")
then I need to loop this to autofilter on Field 20 but I realise I can't use
ActiveSheet.Range("$A:$T")
as I get Autofilter method of Range class failed.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe post your spreadsheet.
Is there a heading in cell S1 (i.e. is the table continuous)?
Is there a heading in cell S1 (i.e. is the table continuous)?
ASKER
Hi Phillip
thanks for the use of your brain. Not sure what it was but by removing the filters completely and then running the code it works.
Have a good Xmas
thanks for the use of your brain. Not sure what it was but by removing the filters completely and then running the code it works.
Have a good Xmas
ASKER