I'm trying to import ASCII string comma delimited to Cells in Excel (rows & Columns) but excel doesn't parse the strings properly using texttocolumn   it keeps asking if I want to replace the contents of the destination cells. I need help with the proper code to parse the strings across columns and then go to next row when the text in text box changes. This text is not a file but a stream that is event triggered. Thanks for the help!

Two suggestions...

(1) Use this...

Application.DisplayAlerts = False

(don't forget to turn it back on)


(2) And/Or...clear the contents of the cells before you start the import...

Cells.Select Selection.EntireColumn.Delete

____________________________
Eggheads unite! You have nothing to lose but your yolks.