read a line from external text files on a random basis

the random number called "RandomNum" got claculated from the total number of lines in each file. Each line is of the same exact length. I wish to read a different line each time.
My issue is where to place that random number in my code? Every try it generate an error.

[Code)

Please Login or Register  to view this content.

[/Code)]

Try:

Please Login or Register  to view this content.

PS. Please edit your post, because it does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

1. Have you tried it? It works. How? Whole file is read into array then closed. After that only needed array element is presented. It is much quicker than reading line by line.
2. Code Tags!!! It's final kind reminder.

1) Not really. Use square closing bracket - can't you see the difference?

2) I don't think you tested my solution at all - IMHO shall be fine for (almost) any computer and file (20 000+ rows and 100+ characters is not a big deal - just few MB).
So I'm a bit disappointed.
But if you do not trust, of course you can read this "snail method" line by line.
Something like:

Please Login or Register  to view this content.

Shall do. In real life you shall also test if your RAndomNum is not out of the last line of the file.