View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Henze Ron Henze is offline
external usenet poster
 
Posts: 1
Default VBA Excel Autofilter Question

Is there a way to return filtered values directly to a variable without
having to step through the visible cells? For example, filtering on
column A and B reduces the filter options displayed in the column C drop
down. I want to use data values in column C dropdown list to generate
graphs. My stepping routine takes a long time (minutes, but now want
seconds...next it will be yesterday :-)
Thanks Ron


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!