Wand
04-26-2013, 04:32 AM
Hi, hope someone out there can help.
I am trying to run the code below but keep getting a runtime error code 1004 - Application-defined or object-defined error.
ActiveSheet.Range("$A$:$Q").AutoFilter Field:=15, Criteria1:= _
MyCell, Operator:=xlFilterValues
I declared MyCell as a Range and want to use it as a filter criteria in my data A$:Q$.
Any help will be much appreciated.
I am trying to run the code below but keep getting a runtime error code 1004 - Application-defined or object-defined error.
ActiveSheet.Range("$A$:$Q").AutoFilter Field:=15, Criteria1:= _
MyCell, Operator:=xlFilterValues
I declared MyCell as a Range and want to use it as a filter criteria in my data A$:Q$.
Any help will be much appreciated.