Advertisement
Guest User

Untitled

a guest
Nov 24th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. Private Sub ButtonCreator_Click()
  2. Dim NumberCells As Integer
  3. NumberCells = Cells(3, 4).Value
  4. For j = 5 To 5 + NumberCells - 1
  5. Cells(3, j).Value = "Column" & j - 4
  6. Next j
  7. For i = 4 To 4 + NumberCells - 1
  8.  
  9. Cells(i, 4).Value = "row" & i - 3
  10. Next i
  11.  
  12. For i = 4 To 4 + NumberCells - 1
  13. For j = 5 To 5 + NumberCells - 1
  14. Cells(i, j).Value = Int(Rnd() * 100 - 300)
  15. Next j
  16. Next i
  17.  
  18.  
  19.  
  20.  
  21.  
  22. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement