View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default TextToColumns Method: How to use xlFixedWidth?

VB or VBA?

In VBA, I'd record a macro when I did it manually.

In VBA, I'd record a macro when I did it manually and then try to change it to
run from VB.

J@Y wrote:

I am trying to simulate what I do manually with the Text to Column function
in Datas menu. Basically I have a range select, I go to T to C function, I
chose FixedWidth, then but 2 separators at 30 and 60. How would I do that
using the TextToColumns in VB?


--

Dave Peterson