Hi,
Hi Sergio, thanks but I cant seem to get that to work either. Really didn't think I would have as much trouble with this.
James, This is what I was initially doing in my Macro. But what I want is the Array for specific Names in Criteria1 and Also have it for all 'SA*' and all 'PR*'
For more detail.
ActiveSheet.Range("$A$1:$Q$5000").AutoFilter Field:=1, Criteria1:=Array( _
"SA*", "PR*", "DSCA", "DSCACBB", "DSCAFMM", "DSCAMM", "MVA3", "PALACGA", "PALACSAD", "PALACST", "PAR3C", "PAR3CORP", "PARTNJ2", "PEG", "PLAZIA", "PLNJSEL", "PLREAL", "PREPALAC", "PREPALCOL", "PREPLNJ", "PREPRIAC", "PRETCB", "UNIONCAR", "VANTAGE", "PLAZMM", "PLAZIL"), Operator:=xlFilterValues
But this Macro doesn't Include my SA* or PR*...... It will include the rest.
Don't know if this is possible but could you have it like this?
ActiveSheet.Range("$A$1:$Q$5000").AutoFilter Field:=1, Criteria1:=Array( _
"DSCA", "DSCACBB", "DSCAFMM", "DSCAMM", "MVA3", "PALACGA", "PALACSAD", "PALACST", "PAR3C", "PAR3CORP", "PARTNJ2", "PEG", "PLAZIA", "PLNJSEL", "PLREAL", "PREPALAC", "PREPALCOL", "PREPLNJ", "PREPRIAC", "PRETCB", "UNIONCAR", "VANTAGE", "PLAZMM", "PLAZIL"), Operator:=xlFilterValues
'And then below have another filter that says... 'Add in all SA*
'And then below have another filter that says... 'Add in all PR*