Reference Open Workheet from Add-in VBA code

[moonbug]

I have a VBA code in an Excel add-in that is suppose to create a pivot table.
How do I reference the worksheet I have opened from the Excel add-in vba code?
I get an error when I execute the line: Set objTable = Sheet1.PivotTableWizard > Run-time error '1004' Application-defined

Please Login or Register  to view this content.

[moonbug]

change Sheet1. to ActiveWorkbook.ActiveSheet