Run code on 1000 files at a time

I have a list of files in column A of a worksheet.
There are 10,000 + files in the list.
I would like to run the same macro on all the files in the list, BUT, processing only 1000 at a time because a worksheet is created for each file and having 10000+ worksheets doesn't work!

I need to test what the last row will be, then set the loop to run to the last row in batches of 1000.
if y = number of batches of 1000
z = number of files

Please Login or Register  to view this content.

Any assistance in shortening this code to avoid loop after loop would be appreciated.

Thanks

Thanks for the assistance Kaper,

z is the last empty row
Number of files is actually z -1 because row 1 is a header row!

I will give your suggestion a trial.