Usman Malik
New Member
- Joined
- Mar 19, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- Mobile
I am working on an excel workbook having multiple sheets. I have placed a macro for the refresh of the pivot table. But after refreshing it return to the sheet i have select at the time of recording the macro. Kindly help me, as i want to return to the active sheet I am working on.
Refersh Macro
'
'
Sheets("Done").Select
Range("B8").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
Range("A33").Select
Sheets("Pending").Select
Range("B9").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
Sheets("19").Select
End Sub
This return me to sheet 19 always
Refersh Macro
'
'
Sheets("Done").Select
Range("B8").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
Range("A33").Select
Sheets("Pending").Select
Range("B9").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
Sheets("19").Select
End Sub
This return me to sheet 19 always