View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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