Intermittent problem with PasteSpecial Method of Worksheet Class Failed

[Photomofo]

I'm downloading some data from a webpage and pasting it to a worksheet. I've gotten most of the bugs out of the process but I'm periodically getting this PasteSpecial Method issue popping up? By periodically I mean 1 out of 1000 page downloads.

How can I test to see if this "alarm" is going to come up? Is there a way to override the alarm and retry the paste? If X error occurs, wait 5 seconds and retry...

Here's the specific snippet of code.

Application.DisplayAlerts = False
ActiveSheet.PasteSpecial Foremat:="Text", link:=False, DisplayAsIcon:=False
Application.DisplayAlerts = True

 

[Photomofo]

Hmmm... It appears the error is occurring on January 1st. January 1st is the trigger in the program to paste a year's worth of data to the worksheet before continuing to download data... Perhaps excel was still busy completing the last paste (a bigger annual paste) so when I ask it to paste January 1st's data it gets hung up? I dunno. I took the annual paste out of the code to test to see if things still hang up?

Nope... Still hanging up periodically.