taraleigh
asked on
ClearContents with pivot table
I have been running the following in line of code in Excel 7.0 but when I convert it into Excel 97 it fals over.
Sheets("Country Act Pvt").Select
Cells.Select
Selection.ClearContents THIS LINE DOES NOT WORK
Part of the area selected is a Pivot table. The error message "Run time Error 1004. Cannot change this part of a Pivot Table"
Could anyone help?
Sheets("Country Act Pvt").Select
Cells.Select
Selection.ClearContents THIS LINE DOES NOT WORK
Part of the area selected is a Pivot table. The error message "Run time Error 1004. Cannot change this part of a Pivot Table"
Could anyone help?
ASKER
But why would it stop clearing the data in 97 when it worked in 7.0?
ASKER
But why would it stop clearing the data in 97 when it worked in 7.0?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I agree you have the answer to why the area cannot be cleared but is there another way of clearing the data without losing the formatting? I was looking for a solution rather than just the reason why it would not work.
I have not rejected your answer and I will accept it if you have another method to use.
I have not rejected your answer and I will accept it if you have another method to use.
How about replacing Selection.ClearContents with Selection.Delete ? You could also condense the two lines of code to one by using Cells.Delete.
ASKER
Thankyou.
The only explanation is the pivot table must have been made up from data in another pivot table in another sheet/ workbook. Otherwise if there were no links there would be no problem clearing the contents.