How to control AutoFilter positioning?


#1

Hi,

I have a sheet that I create an AutoFilter range on. The data and corresponding column headings start on A3 and ranges up to BW77.
I now assign AutoFilter.Range = “A3:BW77”, however the filter is located at A1, ie the filter drop down cells show up on row 1 and selections include column headings.

Any help would be appreciated

Regards

Kai Iske


#2

Hi Kai,

Please try the latest hotfix. It’s fixed.


#3

Thanks Laurence, that did it