VBA Type Mismatch Error when creating PivotCache

Hi,

I am trying to make a Pivot Table in Excel 2003 using VBA and am getting a run-time error 13 Type mismatch on the red line below where I am trying to create my Pivot Cache. Any thoughts?

Please Login or Register  to view this content.

Thanks!

What are the values of FinalRow and FinalCol?

Note: you must use code tags when posting code on the forum; I have added them for you on this occasion but please ensure you use them in future.