Error Handling in a loop

[Turtleman10]

I have a loop that when there is an error it will record the workbook name and all its info in another workbook then move on to the next workbook. This all works great. the problem is the next time it loops though it steps through my error code even though there is no error I thought I would be clever and check the error code but the error code never goes back to 0 so if it's 1004 the next time I check it its 1004 any help would be great.

Please Login or Register  to view this content.

[romperstomper]

I can't see a loop there but you can use Err.Clear to clear the current error.

[Turtleman10]

That's what I needed. Thankyou