Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What does TrailingMinusNumbers do in the TextToColumns Method | Charts and Charting in Excel | |||
TextToColumns Method - Delimited by Double Spaces | Excel Programming | |||
Q TextToColumns | Excel Programming | |||
texttocolumns | Excel Programming | |||
How to use Opentext method with xlFixedWidth? | Excel Programming |