VBA workarounds = wonderful (no error)

Excel Forum workarounds = frustration "Type Mismatch. Please be sure you are accessing the correct URL before proceeding !"