Auto Filter. More

C

Connie

Diane Thank you.

I tried
ActiveSheet.AutoFilterMode = False

which seems to work OK

but when I try
ActiveSheet.AutoFilterMode = True it never works.

Can you tell what I'm doing wrong?

Thanks again,

Connie
-----Original Message-----
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
.
Click to expand...
..
 
F

Frank Kabel

Hi
have a look at the Excel help file for this :)
AutoFilterMode can only be set to FALSE. If you want to enable
autofilters you have to use the AutoFilter method
 
Top