Hi, I have sucessfully used Ron de Bruin's, Copy Txt to new worksheet macro.
My txt file now however has more lines than what 1 excel page can handle.
Is it possible have the macro identify the last line imported into excel and
place all remaining lines onto a new page?