I am trying to refresh a pivot table on a separate workbook using vba.
Here is the code:I get the error about being out of range on the 'Set' line of code.![]()
Please Login or Register to view this content.
Why?
I am trying to refresh a pivot table on a separate workbook using vba.
Here is the code:I get the error about being out of range on the 'Set' line of code.![]()
Please Login or Register to view this content.
Why?
The workbook name is wrong, or the sheet name is, or the pivot table name is.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks