Element Not Found

[danmarsh]

Hi there,

I am about to pull my hair out with this one. I've got the code below that I have not changed and has been running just fine. Now I get an error saying Element not found at the ActiveSheet.PasteSpecial line. I haven't changed my reference and they are:

Visual Basic Applications
Microsoft Excel 14.0 Object Library
OLE Automation
Microsoft Office 14.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft HTML Object Library
Microsoft Internet Controls.

Please Login or Register  to view this content.

Please help!

[JosephP]

any updates to Internet explorer since it last ran successfully?

[danmarsh]

Looks like this worked:

Please Login or Register  to view this content.

[danmarsh]

I don't know what caused it. But I figured it out.

Thanks!