Error handling not working in "vba object variable or with block variable not set" in Loop

[caabdul]

Hi


I have On Error "GoTo ErrorHandler" in my code

It works fine in first loop and Goes to ErrorHandler on error but in second loop of 'heads' it gives error as follows.

"vba object variable or with block variable not set"

Please Login or Register  to view this content.

Note: Error is happening because in both of 1st and 2nd loop the value is not found from the sheet. That is Ok but I want the code to go to ErrorHandler: when there is error in 2nd loop, instead of showing the error.

Thanks

[protonLeah]

Please Login or Register  to view this content.

[rorya]

As to why it happens: http://excelmatters.com/2015/03/17/on-error-wtf/

[caabdul]

Thanks Rorya, it worked