Error: Autofilter method failed even though it didn't fail

[Matt_]

on combobox change, filter a table based on combox:

Please Login or Register  to view this content.

it filters my table correctly, but then it gives me a 'runtime error 1004 autofilter method of range failed'

[Paul]

Hi Matt, welcome to the forum.

Can you upload a sample copy of your workbook rather than us trying to build one that won't likely match yours? Replace any confidential data with fake data, of course.

Thanks.

[Matt_]

Filter Help.xlsm

example workbook

[Paul]

Hi Matt,

Try this updated code (thanks to Mikerickson here: http://www.ozgrid.com/forum/showthre...162#post572162)

Please Login or Register  to view this content.

I honestly don't know why it works, but it does. (Even weirder - the code still gets triggered twice, the second time 'abort' is True (it never even got to the "abort = False" line) so it proceeds to Exit Sub, however it doesn't - it just skips the filtering line and then goes to the next line setting 'abort' to False before exiting the Sub.) ::shrug::