First array value in Text2Col

[Rudi]

Hi,

Anyone know what the first value represents in the T2C array?
Selection.TextToColumns Destination:=Range("D1"), DataType:=xlDelimited, FieldInfo:=Array(1, 4)

I've experimented with it, changing it to 2 or 3 , etc.. and I don't see much change.
Any ideas?

TX

[HansV]

For xlDelimited, the first value is the column number. For example, if you're going to split the data into 3 columns, you could use

..., FieldInfo:=Array(Array(1, xlTextFormat), Array(2, xlGeneralFormat), Array(3, xlDMYFormat))

to specify that the first column should be treated as text, that Excel may decide the format of the second column, and that the third column contains dates in DMY format.

For xlFixedWidth, the first position specifies the starting position within the text string.

[Rudi]

Ah, that clarifies. TX.
I was using T2C to simply clean up text dates, so there was no "splitting" involved; hence the confusion.