PDA

View Full Version : reset filter mode



lior03
01-05-2006, 07:53 AM
hello
i have a filtered sheet .how do i reset it back to off
using vba?
thanks

Bob Phillips
01-05-2006, 08:15 AM
If ActiveSheet.AutoFilterMode Then
Cells.AutoFilter
End If

matthewspatrick
01-05-2006, 08:16 AM
If Not ActiveSheet.AutoFilter Is Nothing Then [a1].AutoFilter