View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jinx jinx is offline
external usenet poster
 
Posts: 12
Default VB for multiple filters

Hi,

is it possible to filter on two columns ?

I'm using

Selection.AutoFilter Field:=12, Criteria2:="ABCD"

to filter automatically, but need to add another selection eg:

If value in Col A = "ABCD" AND value in Col B = "DEFG"
then
Display = True

thanks
Jinx
--
Thanks... Jinx