How to make reference to a PivotTable

[j_Southern]

I have a worksheet which has several PivotTables.
I would like to be able to refer to them in code with something like this:-

Please Login or Register  to view this content.

This does not work The Pivot table name is not recognised.

Can anyone point me in the right direction please
John

[xlnitwit]

You don't want quotation marks around the n as it is a variable not literal text

Please Login or Register  to view this content.

[j_Southern]

xlnitwit,
Thanks for your help. it works fine now.
I feel just a little bit stupid for not seeing it myself.
John