ok so I have my file that some cells are multiline cells... I want to separate the multi line cells in the next column... for which I have this code:
Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote...