Autofilter starts in row 2 / Exce2010

[maatman]

Hi,

If I apply an autofilter in my worksheet the autofilter dropdownmenu stands in row 2 and not in row 1. How is this possible?
It drives me crazy!

Best Regards, Martin

 

[Dryver14]

The auto filter assumes you have headings in row 1

 

[maatman]

Yes, but is that a problem? I have headings also on other sheets in row 1, but there the dropdownmenu starts in row 1. Why the inconsistency?

 

[maatman]

Is there a code in Visual Basic to always start the autofilter in row 1.