Reply to Message

because code from prior versions of excel trying to determine whether an autofilter is enabled or not does not work. there are obviously 2 different filters used, one for tables and one for autofilters.

try this in the immediate window when a table is created
?worksheets("Sheet1").autofiltermode

it will return false