Guest User

Untitled

a guest
Jan 20th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. Sub Skipper(ByVal ListRng As Range, ByVal PrintRng As Range)
  2. Dim Elm As Variant
  3. Dim BufStr As String
  4. Dim buffer() As String
  5.  
  6. ' Add in Uniq List
  7. For Each Elm In ListRng
  8. If Elm <> vbNullString Then BufStr = BufStr & "|" & Elm
  9. Next Elm
  10.  
  11. ' Put selected elements into buffer array
  12. buffer() = Split(BufStr, "|")
  13.  
  14. ' Print
  15. Set PrintRng = PrintRng.Offset(-1, 0).Resize(UBound(buffer) + 1, 1)
  16. PrintRng = WorksheetFunction.Transpose(buffer())
  17.  
  18. Erase buffer
  19. Set ListRng = Nothing
  20. Set PrintRng = Nothing
  21.  
  22. End Sub
Add Comment
Please, Sign In to add comment