The AutoFilter property toggles, so you need to check its state using
AutoFilterMode:


'turn on autofilter
If Not Worksheets("Sheet1").AutoFilterMode Then
Worksheets("Sheet1").Range("A1").AutoFilter

'turn off autofilter
If Worksheets("Sheet1").AutoFilterMode Then
Worksheets("Sheet1").Range("A1").AutoFilter



"gregork" wrote in message
...
I want to turn the auto filter off (or show all) on a worksheet whenever a
userform is initiated. Is it possible to write code in the userform
procedure to achieve this?

GK