Selection.AutoFilter Field:=19, Criteria1:=Range("A1").Value

--
Regards

Juan Pablo González

"DB100" wrote in message
...

Hi Guys

Can anyone tell what the additional code would be to set this auto
filter to a cell reference. So that when the Macro runs it filters the
contents of the Cell A1 for example

Thanks

Selection.AutoFilter


Selection.AutoFilter Field:=1, Criteria1:="a2"

Selection.AutoFilter Field:=19, Criteria1:="a1"

Thanks


--
DB100
------------------------------------------------------------------------
DB100's Profile:
http://www.excelforum.com/member.php...fo&userid=9176
View this thread: http://www.excelforum.com/showthread...hreadid=268145