Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. .Columns("D").TextToColumns Destination:=Range("D1"), DataType:=xlDelimited, _
  2. TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
  3. .Range("A2").Resize(UBound(resultsArr, 1), UBound(resultsArr, 2)) = resultsArr
  4. Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
  5. :=DELIMITER, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, _
  6. 1), Array(6, 1), Array(7, 1), Array(8, 1), Array(9, 1), Array(10, 1), Array(11, 1), Array(12 _
  7. , 1), Array(13, 1), Array(14, 1), Array(15, 1), Array(16, 1), Array(17, 1), Array(18, 1), _
  8. Array(19, 1), Array(20, 1), Array(21, 1), Array(22, 1), Array(23, 1), Array(24, 1), Array( _
  9. 25, 1), Array(26, 1), Array(27, 1), Array(28, 1), Array(29, 1), Array(30, 1), Array(31, 1), _
  10. .Columns("D").TextToColumns Destination:=Range("D1"), DataType:=xlDelimited, _
  11. Array(32, 1), Array(33, 1), Array(34, 1), Array(35, 1), Array(36, 1)), _
  12. TextQualifier:=xlDoubleQuote,Other:=True, OtherChar _
  13. TrailingMinusNumbers:=True
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement