Oh hey I figured this one out. Thanks to Derek Rose and his link he
sent me about pivot tables I also found a treasure of information about
anything excel and they had a section on autofilter  coding. It ended up
being selection.autofilter = false. Thanks Derek. In case anyone else
is interested the link is



http://www.contextures.com/tiptech.html