Solved: Copy data from multiple files to a single worksheet

[GTO]

I see nothing at all wrong with the way that you are using it, setting it to suppress an anticipated error, and resetting immediately afterwards.

If only I had a brain...

Apologies for my lack of clarity, as I forgot the error handling in ShExists() and now am not sure if we are both referring to the same bit. I think so, as I referred to having the Resume Next in the handler, but just to ensure, I am asking about the tail end of SourceFile_ExtractData().

While I failed to include an On Error GoTo 0, from my understanding, as the function is called but calls no other function, the error handling would revert to whatever is in the calling sub upon exiting the function. (In this case, no error handling in the calling sub) Do I have that part right?

The only difference that I apply is that I delegate anticipated errors like that into single task functions that contain the error handling.

If we are referring to the same bit, I do not understand how this would work?

Thank you for your patience Bob; it is always appreciated.

Mark