Dear Friends ,
Iam a newbie to VBA trying the record the macros and then amend according the needs , leaning from Mr Excel forum ,
i am not sure what is wrong with the code , i am getting the error on this particular line
Set Pt = pc.CreatePivotTable(ws.Range("A8"))
Error " Run time Error 91 Object Variable or with Block Variable Not Set
Appreciate your help
Iam a newbie to VBA trying the record the macros and then amend according the needs , leaning from Mr Excel forum ,
i am not sure what is wrong with the code , i am getting the error on this particular line
Set Pt = pc.CreatePivotTable(ws.Range("A8"))
Error " Run time Error 91 Object Variable or with Block Variable Not Set
Appreciate your help