Sorry I just saw your message now, glad that your problem is solved

Had to replace the TableDestination with teh value of pivot_sheet_obj.sheet.Range("B2")
2
1
Hunter Camfield
KahEm Chu
·Follow
Jun 15, 2021
--
Sorry I just saw your message now, glad that your problem is solved
--
--
Written by KahEm Chu444 Followers
·67 Following
Date Science and Analytics Graduate. Passionate in data science, decision science and automating stuff =]
No responses yet
Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams