hello guys, im trying to run this macro on a huge amount of data and every time i receive this error
thanks for the help in advance
Run-time error '1004' Text to columns method of range class failed
Selection.TextToColumns=Destination:=Range("B2"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
:="|",FieldInfo:=Array(Array(1,9), Array(2,1), Array(3,9), Array(4,1), Array(5,9), Array(6,1), Array(7,9), Array(8,1), Array(9,9), Array(10,1), Array(11,9), Array(12,1), Array(13,9), Array(14,1), Array(15,9), Array(16,1), Array(17,9), Array(18,1), Array(19,9), Array(20,1), Array(21,9), Array(22,1), Array(23,9), Array(24,1), _
TrailingMinusNumbers:=True
Bookmarks