Can you have two .Autofilters in the same macro?

[James Snyder]

I know, it sounds like a silly question, but if I have an Autofilter range on one workbook and a .Find being used on the range, can I use an Autofilter on a second workbook? I am trying to use each within a set of "With" blocks...

 

[Firefly2012]

Yes you can. The With (assuming it is specific to a particular workbook) will only work on one of them though, so the other will need to be written out in full.

 

[James Snyder]

Much thanks! I was worried that it might have been "Microsofted" like the .Find...