fer cryin' out loud....

I forgot the '=' in front of the range name when referencing the pivot table.

=OFFSET(MasterJobList!$A$2,0,0,COUNTA(MasterJobList!$A:$B),20) is called pivottableref.

When I create the pivot table, I type in =pivottableref and it works fine.

Thanks for joggin' those brain cells VBA noob.