Pivot Table Runtime error 1004

Hello all,

i'm hoping someone could help me with an issue i'm having creating pivot tables. i'm am getting a runtime error 1004 on the below line. I've posted the rest of the code below for reference. any help would be much appreciated.

Thanks,

Chris

Please Login or Register  to view this content.

Please Login or Register  to view this content.

PT does not work well with range. Change the range in to a string.

Please Login or Register  to view this content.

I also assumed that you have a code sheet name called SheetNum.

unfortunately not, there is a lot of confidential info and data in it, i'll see if i can strip out the confidential data and make a basic file with just the relevant code

unfortunately not, there is a lot of confidential info and data in it, i'll see if i can strip out the confidential data and make a basic file with just the relevant code