Script is hanging up on a paste

[Photomofo]

I have a simple code that navigates to a URL, copies a page and pastes the page onto a worksheet. The code is designed to cycle through a series of dates. The code is currently executing the first paste but it hangs up on the second paste. Any ideas?

        'Application.DisplayAlerts = False
        
        ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _
        False, NoHTMLFormatting:=True
        
        Application.DisplayAlerts = True

 

[Photomofo]

I've tried running this program on three different computers now and all three are hanging up on the PasteSpecial step. This is strange. This program used to chew through 50 web pages a minute. It's also strange that when I press the ESC button to kill the program it finally pastes the data and processes it.

 

[Anthony47]

I've tried running this program on three different computers now and all three are hanging up on the PasteSpecial step. This is strange. This program used to chew through 50 web pages a minute. It's also strange that when I press the ESC button to kill the program it finally pastes the data and processes it.

So it is quite sure the problem depends on the data you are trying to paste.

For possible help you should disclose the url of the web page and the code you use to import the information

Bye