Rather than re-invent the wheel, see: https://stackoverflow.com/questions/...n%20an%20array.

Or Google: excel vba to read entire text file into an array for more suggestions.