Thread: using auto filter, how to tell what columns are filtered?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default using auto filter, how to tell what columns are filtered?
Tom does nice work!

Robert Mark Bram wrote:

Thanks Dave,

Once I worked out the "general module" bit, I got your version working
nicely.
=ShowFilter(B5)&left(Subtotal(9,B5:B200),0)

Well Done!

Rob
:)

--

Dave Peterson
Reply With QuoteReply With Quote