Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. Dim i As Integer
  2. With machwas.ListBox1
  3. For i = 0 To .ListCount - 1
  4. If .Selected(i) Then
  5. If Cells(last, 6).Value = "" Then
  6. ActiveSheet.Cells(last, 6).Value = .List(i)
  7. If Cells(last, 7).Value = "" Then
  8. ActiveSheet.Cells(last, 7).Value = .List(i)
  9. If Cells(last, 8).Value = "" Then
  10. ActiveSheet.Cells(last, 8).Value = .List(i)
  11. If Cells(last, 8).Value = "" Then
  12. ActiveSheet.Cells(last, 8).Value = .List(i)
  13. If Cells(last, 9).Value = "" Then
  14. ActiveSheet.Cells(last, 9).Value = .List(i)
  15. If Cells(last, 10).Value = "" Then
  16. ActiveSheet.Cells(last, 10).Value = .List(i)
  17. If Cells(last, 11).Value = "" Then
  18. ActiveSheet.Cells(last, 11).Value = .List(i)
  19. If Cells(last, 12).Value = "" Then
  20. ActiveSheet.Cells(last, 12).Value = .List(i)
  21. If Cells(last, 13).Value = "" Then
  22. ActiveSheet.Cells(last, 13).Value = .List(i)
  23. If Cells(last, 14).Value = "" Then
  24. ActiveSheet.Cells(last, 14).Value = .List(i)
  25. End If
  26. Else
  27. End If
  28. Next i
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement