Text to Columns using VB

[jtrevill]

So - anyone know of a way to use Text To Columns, but by using V
instead?

Thanks

 

[Guest]

There is a split function for Delimited data. It returns an array of the
individual fields in the record.

 

[Tim Williams]

Selection.TextToColumns DataType:=xlDelimited, Comma:=True

Tim.