kevvukeka
05-30-2013, 12:18 AM
Hi All,
At one point in my code I have to split a selected range at hyphen into another column. I used the below code, but it doesn't have any effect on the range. can someone help plz?
Range("A2:A" & j).Select
Selection.TextToColumns
Destination:=Range("A2"), DataType:=xlDelimited, OtherChar
_
:="-"
At one point in my code I have to split a selected range at hyphen into another column. I used the below code, but it doesn't have any effect on the range. can someone help plz?
Range("A2:A" & j).Select
Selection.TextToColumns
Destination:=Range("A2"), DataType:=xlDelimited, OtherChar
_
:="-"