View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MagnuM
 
Posts: n/a
Default How to hide columns that are not filtered?

Hello,

I'm a newbee and maybe somebody can help me out.
What I need is a code that hides columns that are not filtered.
E.g.: If I filter column A, the columns B:F should be hidden, if I filter
colums A+C then B, D ,E and F should be hidden etc.

Hopefully someone can help me out

TIA

KR

Berry