Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. Sub Matrix()
  2.  
  3. Dim i As Integer
  4. Dim a As Integer
  5.  
  6. For a = 1 To 5
  7. For i = 1 To 30
  8. Selection.Copy
  9. ActiveCell.Offset(1, 0).Select
  10. ActiveSheet.Paste
  11. Next i
  12.  
  13. ActiveCell.Offset(-i + 2, 1).Select
  14.  
  15. Next a
  16.  
  17.  
  18. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement