Unanswered: putting/dividing a text entry into columns
I've been able to change a text entry into columns by using command Data - text to column in Excel, but I can't find a way to use it in VBA. Anyone can help me?
Example : the input is ABCDEFGHIJ and i want to put them in ten separate columns automatically from an input box. Thanks before.