You can only apply the autofilter to a contiguous range. But you can use code
to remove the dropdown arrows from the columns where you don't want them.

See Debra Dalgleish's site:
http://www.contextures.com/xlautofilter03.html#Hide

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
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.)

Dave wrote:

Hi

Is there anyway of removing the auto filter from certain columns. I only
want it on the first two and want to be able to remove or hide the button
from the rest?

Thanks

--

Dave Peterson