Run time error 5, invalid procedure call or argument

**arvimeld** · 08-06-2018, 07:43 AM

Hi,

I have a code that filters out every possible filter for a pivot table and copy specific values to other sheet.
It works fine, but it has suddenly crashed already twice.

It goes like this:
- Everything works fine;
- Suddenly, without any logic, error appears in a middle of code doing its work. It loops through approx. 40 filters out of 70 and then crashes;
- From now on, it will continue to crash at the same place;
- If I will copy all data and file structure to a new workbook and will apply the same code, it will again work (due this I don't see any logic, why the code crashes).

Any idea what this might be related to? New sheets added to workbook? New pivots created in a workbook?

Code below (yellow - line where error appears):

Please Login or Register  to view this content.

**Zer0Cool** · 08-06-2018, 09:11 AM

You may consider adding a break point in your code, debug.print lines throughout and/or adding watches to variables and step through your code (F8) to trace the problem.

The error generally has to do with trying to call a procedure or object/argument that is misspelled or for which the syntax is off the mark. This however can happen in loops when the loop arrives to a place outside the bounds of the objects/collection you are working within.

The line you highlighted seems to me, out of context, to be redundant or at least more than what you may need. Your already via your For Each looping "selecting" your pivotitem, I am not sure what added value assigning the value of the pivot item to currentpage adds.

More than likely at the step it fails the pivotitem value is not a valid currentpage value. For example the pivotitem having a value something like "Sheet 1" when the actual sheet is "Sheet1".