TextToColumns Method: How to use xlFixedWidth?
 

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?

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