View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
count count is offline
external usenet poster
 
Posts: 64
Default Advanced filter in VBA - criteria in non-adjacent ranges

Hi,
Can this be done?
I need to be able to submit filter criteria from 2 simple ranges (say 3
by 3 each) but they sit in different locations (on the same sheet though). I
suppose, I could temporarily merge them in some hideaway prior to use but
I'm trying to avoid it.

TIA
Paul