Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick question
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Question | Excel Discussion (Misc queries) | |||
Quick Question | Excel Discussion (Misc queries) | |||
quick question | Excel Discussion (Misc queries) | |||
Quick Question | Excel Worksheet Functions | |||
Quick little question | Excel Discussion (Misc queries) |