Zillow API VBA

Hello Excel World,

I downloaded a VBA code off the internet to get me zillow.com information (real estate website that gives rent estimates and property estimates among other details). All that you do is plug in the address and information is spit out. It works very well with one exception when it gets stuck. A problem occurs when it tries to pulls a rent amount (called rent Zestimate) or a property value (called Zestimate) that is "UNAVAILABLE", then run-time error 91 pops up. My goal is to allow the code to keep running and/or simply skip over that address and it's details and continue down the list.

Below is the code, I tried to make it in a cool little box so it doesn't take up so much space but gave up.

Thank you,
CrazyDg99

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

You need to set a nothing range for all nodes which are empty.
If you look at one of your line of code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

if the info is empty, it does not error.
You also need to add to other parts of the code in which there is no data.
For instance:

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

Originally Posted by pcollins23

CrazyDg - do you know how to break out the property details into additional columns instead of including the link? I'm trying to identify the year property's were built without clicking the link. Any help would be appreciated

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

This thread is over 2 years old, kr007, so if the update isnt here now, it probably wont be updated.