Can someone help me with an explanation of how QueryTable.AfterRefresh works?
I would like to have some functions called after the automated refresh, but I am unsure how to use the afterrefresh event in my VBA code. I want the code to run regardless of what sheet the user is looking at as the refresh occurs.
Where does the code go? In a module?
I would like to have some functions called after the automated refresh, but I am unsure how to use the afterrefresh event in my VBA code. I want the code to run regardless of what sheet the user is looking at as the refresh occurs.
Where does the code go? In a module?