Read range of data line by line which is increasing dynamically

[min9ox2]

I need to read or clear all the line in specific range which will be increasing dynamically. Problem is "Selected File List" table range is not specified. New file chosen with browse will be added to "Selected File List" dynamically. Number of file can't be predicted.

vbaStk.JPG

What I've tried so far is, keep track of the browse button click and add the file path to arraylist. After that, (Row number 9 which is start line + arraylist size) to get the number of line of end of the table. But due to some requirement, I want to read the file from excel file. Something like -Read until found blank line or border bottom or something.

I'm new to VBA and I'm not so sure what I'm doing with vba codes so please be kind :D

Any input would be greatly appreciated. Thanks for your precious time.

[nathansav]

Do a dynamic named range, so =Offset(a1,0,0,counta(A:A),1) for your file locations

then say range("FileLOcations").rows.count