Hi Guys

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

Thanks

Selection.AutoFilter


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

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

Thank

--
DB10
-----------------------------------------------------------------------
DB100's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=26814