Thanks for the help/code, I'm a little busy right now so I wasn't able to check your code to see if it works, but I appreciate the help anyways. Thanks.
Thanks for the help! Much appreciated. I'm testing it across the markets I'm using (modifying for sheet name and url). However for some reason it did not work for this link:
I get the following error:
An Error Occurred: 91 - Object Variable or With Block Variable not set
Is there a way around this?