" on error goto " not working on second time an error occurs

**JasperD** · 12-22-2014, 07:30 AM

Hi all,

I've got a bit of code that pulls data from a website and then handles it.
Part of the code is the following:

Please Login or Register  to view this content.

where on encountering an error, going to nxc means skipping the whole code and goes to the "next cell" (hence nxc

)
When I run this on an url that would error out on the "title" line, it gracefully skips the code by going to nxc and then runs the next url.
However, the next url errors out on the same line, yet instead of skipping it, it will give me an error saying :

Run-time error '91':
Object variable or With block variable not set

I know what causes the error. I do not know why it won't skip to nxc the second time around.
Does anyone have any bright ideas for me?

**Norie** · 12-22-2014, 07:38 AM

You could just add this after the line that might error,

Please Login or Register  to view this content.

or, since you know the error that's occurring and why it's occurring, you could handle the error without using On Error Resume Next.

**JasperD** · 12-22-2014, 07:40 AM

Thanks norie.
With my head too much into the code, I actually forgot to put the resume next before looping to the next cell.
On error goto 0 would work if I didn't want to skip a whole bunch of code because the error basically means I returned an empty url.

Thanks for pointing me to the obvious