Advertisement
olie480

EXCEL: Copy value certain amount of times down column

Nov 11th, 2013
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub FillDown()
  2. n = InputBox("Enter number of times to copy")
  3. Selection.Copy
  4. For i = 1 To n
  5.   Selection.Offset(Selection.Rows.Count, 0).Select
  6.   ActiveSheet.Paste
  7.   Next i
  8. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement