Autofilter on non contiguous column ranges

  • Thread starter Thread starter pickytweety
  • Start date Start date
P

pickytweety

Hi,
I have a worksheet with data in columns B through D, and F through H. When
I put an Autofilter on, I don't want a drop down arrow in column E (because
there is no data in Column E). Does anyone know if there is a way to slap a
filter on non-contiguous chunks of columns?
 
Autofilter will not handle multiple ranges. You can hide Column E. Does
that help? Otto
 
You can apply the filter to B:H and hide the arrow in column E using code.

Debra Dalgleish shows how:
http://contextures.com/xlautofilter03.html#Hide

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 
Back
Top