Debugging - Compile error: Invalid Next control variable reference

I wrote the following code to import text data and fill in an excel database with the data from the imported text file. The text file is then deleted, a new text file imported and the cycle repeats. However I'm getting a Compile error: Invalid Next control variable reference at Next FileNameCell How can I fix this? Thanks!

Please Login or Register  to view this content.

You have two for loops but only one next.

The codeis executing the for i = 2 to 1000 loop and encounters next filenamecell. You need to add next i somewhere.

I would assume you need this:

Please Login or Register  to view this content.

Stan,

Your code will give an error, you don't need the end if because the if statement is all contained on the single line.

I also think the next i should go before cells.select as otherwise you are just repeating the lines from cells.select to clearcontents, no need to have those in the loop.

The code I posted in post 2 should be correct.

Thanks guys, Can't believe I missed something so simple