Error '1004': Method 'Goto' of object '_Application' failed

Question

Referring to following image, "Web108" is existed, but why do I still get following error?

Based on experience, it used to run without any problem, but this error only occur within this week.

Any suggestions?

Thanks in advance for any suggestions :)

Answer 1

Is that worksheet protected?

Answer 2

Once I stop macro, and check excel worksheet, it seems freeze, and not able to do anything.

Any coding can check on what is going wrong?

Any suggestions?

Thank you

Answer 3

it seems freeze, and not able to do anything

It implies that the sheet could be protected.

On the other hand, it could be that Application.ScreenUpdating being False is still in force if you have stopped the macro.

Try typing:

Application.Screenupdating=True

into the Immediate pane and press Enter.

That might free up the apparent freeze.

I can't think of any code to apply to diagnose this. Would need to see the workbok.