Pivot Table Macro with Mac Office 2011

[jeremyweinman12]

Hi,
I'm having problems creating a macro that will create a pivot table. I'm using Office 2011 for the Mac. When I try to run my macro, I get the following box that pops up:

"Microsoft Visual Basic"
Run-time error '5':
Invalid procedure call or argument


What am I doing wrong?

Thanks,

Jeremy