Quote:
A quick question about:
FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)),
This was recording generated and I'm not sure of its function.
|
Me neither. It definitely has something to do with the number of delimitation's the macro recorder was looking at
but if I reduce the generated line to just this things still seem to work as I would expect so I wouldn't be too concerned.
Code:
.Range("C5:C14").TextToColumns Destination:=Range("C5"), DataType:=xlDelimited, Semicolon:=True
The macro recorder tends to include everything associated with what it's doing even when most of it may be default settings.
If you run into issues, attach a sample workbook to investigate.
07-20-2017, 01:03 PM
Similar Threads
Cell formating on Protected worksheet
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode