Error 1004

[vba317]

I am getting this error 1004. The error is highlighted in blue. I am not sure why I am getting this error. Any help is appreciated.
Tom

With goXL.ActiveSheet
    .Range("B9").Select
[blue]    .PivotTables("PivotTable1").PivotCache.Refresh [/blue]
End With

 

[dhookom]

I expect you should ask this question in forum707.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

try this...

With goXL.ActiveSheet
    .Range("B9").Select
    .PivotTables(1).PivotCache.Refresh 
End With

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}