VBA Express Forum
>
VBA Code & Other Help
>
Excel Help
> reset filter mode
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.