Excel application screenupdating does not work
Using slicers in VBA is actually more reliable that .
Manual Update = False End Sub Latest versions of Excel has a new tool called Slicers.
Orientation = xl Column Field Then Dim i As Long On Error Resume Next ' Needed to avoid getting errors when manipulating fields that were deleted from the data source.
Screen Updating = True End Sub I get something along the lines of Sub Filter Pivot Table() With Active Sheet.
Screen Updating = True End Sub I think i am understanding your question.
The 6 sheets are shown in this illustration describing their function.
These applications have been designed by Trevor Easton for training purposes. The application as is or modified in not permitted for sale in any form.
No warranties are implied or given with this application.
Screen Updating = True End Sub I want to filter so I see all rows that have Saved Family Code K123223.
' Set first item to Visible to avoid getting no visible items while working .