Text to Columns using VB
 

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

Thanks

--
jtrevil
-----------------------------------------------------------------------
jtrevill's Profile: http://www.excelforum.com/member.php...fo&userid=1660
View this thread: http://www.excelforum.com/showthread.php?threadid=31463

Text to Columns using VB
 

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

"jtrevill" wrote:


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

Thanks!


--
jtrevill
------------------------------------------------------------------------
jtrevill's Profile: http://www.excelforum.com/member.php...o&userid=16601
View this thread: http://www.excelforum.com/showthread...hreadid=314637

Text to Columns using VB
 

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

Tim.


"jtrevill" wrote in message
...

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

Thanks!


--
jtrevill
------------------------------------------------------------------------
jtrevill's Profile:
http://www.excelforum.com/member.php...o&userid=16601
View this thread: http://www.excelforum.com/showthread...hreadid=314637