Autofilter on non contiguous column ranges

[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?

 

[Otto Moehrbach]

Autofilter will not handle multiple ranges. You can hide Column E. Does
that help? Otto

 

[Dave Peterson]

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.)

 

[Don Guillett]

If there is no data then what difference could it make?