Faster way then VLookup?

[trevor2524]

I have the following code:

Please Login or Register  to view this content.

It keeps timing out when I run it. Is there a faster way to get through 20k files when I'm just trying to pull the information from another sheet? I have it to stop running when on Sheet 2 Column B has no value that is why I'm running it through a loop.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[trevor2524]

Thanks John.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.