Thread: using auto filter, how to tell what columns are filtered?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Robert Mark Bram Robert Mark Bram is offline
external usenet poster
  
Posts: 5
Default using auto filter, how to tell what columns are filtered?
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
:)
Reply With QuoteReply With Quote