While Using Value from Range D3:D in String, if (D, x) = "" doesnt skip to next row??

Put Set rng = rng.Offset(1) after End If and before Next j so the row offsets for each j regardless if D is empty.

Please Login or Register  to view this content.

Alternatively, offset the column .Values from rngCode as that is the current column D cell.

I thought that was where the error was coming from.. apparently didn't move it to the right place. Thanks again.

I'm running into another problem, if you have a moment. i keep running into an object variable, or with block variable not defined error.. doesn't give me a debug option though, so i have no idea where to look.. but it happens with the same bit of code as above at row 184 column M.. I'm not sure how to get it to just get past the error.

This line fills column M

rng.Offset(0, 12).Value = nodes(nd + 1).Attributes(1).Value

My guess is that nodes(nd + 1).Attributes(1).Value doesn't evaluate for a specific movie for some reason. I cannot say why without seeing the web page.

Check the length of the attributes collection.

That's exactly the Line, that portion is supposed to pull the image link, and i looked that page it was searching, and it became very apparent why it errored out, theres no <Images attribute
what would you suggest to skip that bit of code, or add a blank value for the time being?

heres the site:

HTML Code: 

Check if there are any nodes, as you've done here for category.

Please Login or Register  to view this content.

Thanks For the help, that fixed it completely. I'm already working on if Data present, goto next cell, as to speed up the whole process.. kinda kicking my butt, but I'm certain I'll figure it out, thanks Again