Hello Excel Forum,

Any idea why does the below code work for some URLs, but doesn't for others?
Set ie = New SHDocVw.InternetExplorer
URL = "http://www.msn.com" 'example URL for which the code works fine
ie.Visible = True
ie.Navigate URL
Debug.Print ie.readystate
I am able to open any webpage, but for some, i'm getting an error the moment i try to print the 'readystate' property:

Capture.PNG

Does anyone know why this is happenening and how to prevent this?

Thanks,