AutoFilter Criteria

Hi,
I was wondering if there was a way to have more than two criterias

Please Login or Register  to view this content.

I believe having more than two don't work? is this correct? and if so, is there a way around this.

thanks.

Are the numbers of interest all in sequence ?

If so you could use an xlAnd with >= and <= tests

If not I agree with carddards that formulae is the way forward, you can insert a temp formulae column at run time and use this as means by which to filter
(clearing temp formulae from sheet at conclusion of routine)