Advertisement
Guest User

Untitled

a guest
May 29th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub test()
  2. i = 0
  3. Do
  4.     i = i + 1
  5.     Cells(i, 1) = i
  6. Loop Until i = 10
  7.  
  8. j = 1
  9. Do While j <= 10
  10.     Cells(j, 2) = j
  11.     j = j + 1
  12. Loop
  13.  
  14. For k = 1 To 10
  15.     Cells(k, 3) = k
  16. Next k
  17.  
  18. l = 0
  19. Do
  20.     l = l + 1
  21.     Cells(l, 4) = l
  22.     If l = 10 Then Exit Do
  23. Loop
  24.  
  25. m = 0
  26. Do
  27.     m = m + 1
  28.     Cells(m, 5) = m
  29.     If m = 10 Then
  30.             Exit Do
  31.     End If
  32. Loop
  33. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement