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
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?