Go to
Baking Ways / Productive Bytes

## Friday, November 18, 2011

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

Hi,

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            .ShowAllData        End If    End IfEnd With