Number in this cell is formatted by text or preceded by an apostrophe Problem

[Leonardo1234]

Hi,
I have a code below & this code is putting data formatted by text or preceded by an apostrophe
This code is putting notepad data to .xlsx

Thnx For The Help

Please Login or Register  to view this content.

[WideBoyDixon]

Probably the quickest solution is to change this line:

Please Login or Register  to view this content.

Remove the " As String" to leave this:

Please Login or Register  to view this content.

WBD

[Leonardo1234]

Getting Error Sir

Run- time Error 9
subscript out of range

error Highlighted line: Let arrOut(Cnt, Clm) = arrClms(Clm - 1)

Please Login or Register  to view this content.

[beyond Excel]

Hi. Try this way:

Please Login or Register  to view this content.

[WideBoyDixon]

Running the amended code with the file you attached in post #1 gives no errors for me. Are you using a different text file when getting the error?

WBD