"John Bundy" wrote:

This will get you the last row in a particular column, I used A:
lastRow = Cells(Rows.Count, "A").End(xlUp).Row

But this only works if the file fits into Excel and can be loaded up. In
this example the file is very often too large to be loaded because the number
of lines is 64k

But for testing purposes I just went ahead and did it the brute force way.
It takes well under 1 second! There's times when VBA does manage to impress
me, and this is one of those times.

Maury