May 4, 2020
Hi - I have a similar issue to Prescott Rose and want to extend this functionality so I can:
Use Auto Filter
Use PivotTable & PivotChart
Can you provide me with the additional VBA code so after spell check this functionality remains? Current code below
'Update by Extendoffice 2018/11/2
Dim xRg As Range
On Error Resume Next
Application.ScreenUpdating = False
Set xRg = .UsedRange
Application.ScreenUpdating = True
December 20, 2019
Always best to add an example workbook so we can see the data or the code and we don't have to recreated.
Have you seen this blog post by Phil?