ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Wait for Pivot Refresh to Complete (https://www.excelbanter.com/excel-programming/331776-wait-pivot-refresh-complete.html)

dan

Wait for Pivot Refresh to Complete
 
Is there a way to wait for a Pivot Table to finish refreshing before
continuing with the code execution?

Thanks,
Dan

Nigel

Wait for Pivot Refresh to Complete
 
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
MsgBox "The PivotTable connection has been updated."
End Sub

--
Cheers
Nigel



"Dan" wrote in message
...
Is there a way to wait for a Pivot Table to finish refreshing before
continuing with the code execution?

Thanks,
Dan





All times are GMT +1. The time now is 09:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com