How do I prevent variable from getting cleared before completing loop

[Wiigit]

I'm getting a runtime error 75 file/path access error due to the script "forgetting" the filepath name stored in ReadTextFile

The file being read looks something like this:

Please Login or Register  to view this content.

Sheet1 looks something like this:

Please Login or Register  to view this content.

And the script is as follows:

Please Login or Register  to view this content.

[Bernie Deitrick]

You have this line

Please Login or Register  to view this content.

That does not skip to the next file... to do that change that line to

Please Login or Register  to view this content.

and add this to just before your Next FileCell line:

Please Login or Register  to view this content.

[Wiigit]

That didn't quite fix it, but I understand better why the script is failing, so I'm going to play with it some more to see if I can figure it out on my own. (Columns A through E have values, and some of those columns are longer than column D, so it's pulling the filename/path from a blank cell)

Thanks!

[Bernie Deitrick]

Your filepath variable is used exactly once, so I don't see any possibility of it being erased or forgotten....