Advertisement
Guest User

Untitled

a guest
Mar 28th, 2017
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. Dim Rng As Range
  2. Dim WorkRng As Range
  3. On Error Resume Next
  4.  
  5. lRow = Range("U" & Rows.Count).End(xlUp).Row
  6. Set MyRows = Range("U19:U" & lRow)
  7. For Each cell In MyRows
  8.  
  9. splitVals = Split(cell.Value, ",")
  10. totalVals = UBound(splitVals)
  11. Range(Cells(cell.Row, ActiveCell.Column + 1), Cells(cell.Row, ActiveCell.Column + 1 + totalVals)).Value = splitVals
  12. Next
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement