Using a variable to as criteria in autofilter

[Wand]

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.

[snb]

[vba]
with ActiveSheet.usedrange.resize(,17)
.AutoFilter 15, MyCell.value
end with
[/vba]

[Wand]

Works perfect.

Many thanks snb, made my day!

[snb]

Too much honour, your Honour.