I am using code that automatically retrieves data from a website. In VBA, I have set up loop to loop through my list of web addresses (in column A in sheet one), retrieves the data, does a bunch of calculations, and then loops to the net address. However, I have found that some addresses do not return any data and cause the previous sets of data to be overwritten (due to some of my formatting code). I am looking for some code to skip the steps if I am unable to retrieve any data. Any help would be greatly appreciated! Thanks in advance!

Loop code:


Please Login or Register  to view this content.


Clinton