Invalid Procedure Call or Argument when Creating a Pivot Table

[nickymac]

Hi,

I am trying to create a pivot based on a varying size of data (rows and columns). Below I have the code, when I step through the code it errors once I get to the Set PTCache line. It' probably something obvious but I can't see it!

(xlws6 is set earlier in the code) - this works. The FinalRow and Final Col both produce the correct numbers. Xlws10 is also set previous to this section.

Please Login or Register  to view this content.