Thread: AutoFilter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jacqui[_2_] jacqui[_2_] is offline
external usenet poster
 
Posts: 30
Default AutoFilter

Can anyone help with the VBA syntax for the following
autofilter. I've written the code below which is fine
provided I just wish to filter on criteria1. (The vChanArr
(n) represents a reporting type of which there can be 10.)

Sheets("Data").Range("DatArea").AutoFilter _
Field:=3, Criteria1:=vChanArr(n)

However, in field 2 of my DatArea range is something I
refer to as a Datatype. This entry can either be a Y or a
M. These signify whether the data is Year to date or
Month of. How would I filter on both the vChannArr plus
my datatype of either Y or M.
I'd greatly appreciate any help.
Many thanks
Jacqui