Runtime Error Message - Pivot Refresh Macro

[jkchild]

Hi

I've created a Command Button from the Control Toolbox menu and added the following code using the view code option.

When I click the button I receive the following message:
"Run time error 1004 application defined or object defined error"
When I click debug the 2nd line of code is highlighted yellow.

Is there something wrong with the piece of code??
Thanks
J

Private Sub CommandButton1_Click()
Sheets("Summary").Range("A6").QueryTable.Refresh BackgroundQuery:=True
End Sub

The pivot table is on sheet Summary and the pivot starts from cell A4

 

[Andrew Poulsom]

Is there a QueryTable in A6 on sheet Summary? A PivotTable is not a QueryTable.

 

[jkchild]

No it's not a query table......It's a pivot table.

Do I just need to update Query Table with Pivot table in the formula? Or can you advise what I do need to do

Thanks
J

 

[Andrew Poulsom]

I would advise you to record a macro while refreshing the pivot table manually. That will give you some code.

 

[jkchild]

Fair play........should have thought of that myself..

Thanks for your time