Prompting user with MsgBox IF runtime error 1004

Hi All

This sounds like it should be simple but I am stuck

I have a script that loops through certain sheets and collates all the pivot table rows

Because the pivot cache is turned off (to save file space as the source data is always saved in the workbook) the user gets runtime error 1004 if they open the workbook and try to call any macros containing ActiveSheet.PivotTables(1) before refreshing the data

So I wanted to add a bit of error handing. Something like this:

Please Login or Register  to view this content.

But now I'm getting run time error 424 - object required?
(The above code is inside a FOR loop if the makes a difference?)

Any/all advice welcome
Many thanks
Vicky

Oh jeez, it was simple

I changed Error.Number to Err.Number and it worked

Thread closed