USPS Address Validation

[lurklurkeylurker]

Looking to sort out this code.

Addresses in A:D hoping to drop USPS validated addresses in F:I to compare and catch errors

I've got the code going to the site, and inputting the origin data, but I can't get the results from the zipcode-result-address to drop back in.

The website I am uploading to has Validation API for USPS, but it is broken and I need a solution to bandaid. Every time I upload a bad address to the site it corrupts the entire input and I'm back to step 1. I'd much rather not validate my 2k sheet one by one .

I have limited plug-and-play knowledge of VBA - Any help is appreciated!

usps_macro.txt