Is there a code to delete existing pivot table?
Currently, I'm trying
Worksheets("Dashboard").Activate
ActiveSheet.PivotTables("PivotTable4").Clear
But it gives an error. I also tried Sheets("Dashboard").Range("B32:H100").Clear and received an error
Someone help?
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Tried that too problem with that is it deletes the pivot above :/
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks