This works for me. ws represents a worksheet, since
AutoFilterMode is a worksheet property.

If ws.AutoFilterMode = True Then
ws.AutoFilterMode = False
End If

Diane
-----Original Message-----
how can I (with VBA) turn off the Autofilter or turn on
the autofilter regardless of its current state?
.