Error in a recorded macro to create Pivot Table

Hello All,
I have recorded a macro to create a pivot table but I get an run-time error '5' when I run the macro. the bit of code that's causing the issue is here

Please Login or Register  to view this content.

First question is how to make the macro work each time and second question is how to ensure that all rows containing data is selected? in the code above the source data is set at R1C1 to R13C5. I will be having more or less number of rows depending upon the actual use case.


Thanks,
Aadesh

It worked! Thanks