I am importing hundreds of delimited text files into a workbook. Each text file can have anywhere from 1 to hundreds of records. So the rows in play would look something like this where 'n' could be any number (probably less than 1000):
Column A Column B
F1 R1
F1 R2
F1 R3
F1 ...
F1 Rn
F2 R1
... ...
Fn R1
Fn R2

Everything I've tried either causes Excel to throw up (out of resources) or takes forever. Does anyone have a good way of computing the number of records for each file as each file is imported, or after all of the files have been reported? Thanks.