Is there a way to call another module as soon as VBA recognises the data source is refreshed,alongside several other pivot tables?
I have used the below, but still doesn't seem to work?
Application.Wait (Now + TimeValue("0:00:10"))
If Application.Ready = True Then
Dim column_number As Integer
I have used the below, but still doesn't seem to work?
Application.Wait (Now + TimeValue("0:00:10"))
If Application.Ready = True Then
Dim column_number As Integer