Guest User

Untitled

a guest
Jan 22nd, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. Public Sub CopyRows(startRow As Long, startColumn As Integer, _
  2. numberOfRows As Integer, numberOfColumns As Integer, repeatCount As Integer)
  3. Dim targetRow As Long
  4. Dim i As Integer
  5.  
  6. ActiveSheet.Range(Cells(startRow, startColumn) _
  7. , Cells(startRow + numberOfRows - 1, _
  8. startColumn + numberOfColumns - 1)).Copy
  9. For i = 1 To repeatCount
  10. targetRow = startRow + (numberOfRows * i)
  11. ActiveSheet.Cells(targetRow, startColumn).Paste
  12. ActiveSheet.Cells(targetRow, startColumn).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
  13. :=False, Transpose:=False
  14. Next I
  15. End Sub
Add Comment
Please, Sign In to add comment