Record macro for Pivot Table

[normpam]

I am doing a simple 'record' of doing a basic Pivot Table, but when I run the recorded macro on the same sheet with the same data, I get the following code highlighted as being a problem:
Is there something special that needs to be done in order to record a basic Pivot Table macro?
Thanks!

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"working copy (2)!R1C1:R70C4", Version:=7).CreatePivotTable TableDestination _
:="working copy (2)!R3C6", TableName:="PivotTable2", DefaultVersion:=7

 

[normpam]

Searched around for quite a while and found a solution....
Need to change TableDestination _:="working copy (2)!R3C6" to have an apostrophe surrounding the sheet name

TableDestination _
:="'working copy (2)'!R3C6"