Please Note that I have changed address
Go to
Baking Ways / Productive Bytes

Search This Blog


Friday, November 18, 2011

Excel how to show all value in a filtered table in vba


If you want to show all value from a filter table, you need to check if there the table is filtered first, otherwise the Sheet1.ShowAllData will fail.
This is the solution

With  Sheet1
If .AutoFilterMode Then
If .FilterMode Then
End If
End If
End With

No comments:

Post a Comment