I am running a macro that will capture data on pivot tables and enter it onto
a template. Some months, for example "Europe" will not come up on the pivot
table because there was no activity to report, but I still need a zero in
place of a #REF when there is nothing to capture.

When I include the On Error Go To 0, nothing happens, It will still come up
with #REF. Can anyone help with this?

Workbooks.Open ( _
"C:\Automated\Pivots.xls")
Windows("Master.xls").Activate
' Europe
-----On Error GoTo 0 <<<<------
Sheets("Europe").Select
ActiveCell.Offset(0, 0).Range("A1:B1").Select
ActiveCell.FormulaR1C1 = _

"=GETPIVOTDATA(""ID"",'[Pivots.xls]Mthly_Ts'!R1C1,""Breakdown"",""Europe"",""Summ""," "OFF"")"
ActiveCell.Offset(1, 0).Range("A1:B1").Select