View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban Alan Beban is offline
external usenet poster
 
Posts: 200
Default Text to Columns in VBA

Then you might as well tidy it up to eliminate the unnecessary selection :-)

Range("A1:A4").TextToColumns Destination:=Range("B1"), _
DataType:=xlDelimited, Comma:=True

Alan Beban

Otto Moehrbach wrote:
Thanks Alan. That goes in my HowTo file. Otto