Copy text in excel cell in rows between numbers from a big text file

  • When I ran the below code with a text file above 20 MB from my excel file, I get an Error showing "L = Val(X)" in yellow, and run-time error type mismatch 13 popped up.

    First I posted it at https://www.excelforum.com/exc…ext-file.html#post5724130 but more help is required. Thanks in advance. -- Jai

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!