Advertisement
Guest User

Loop

a guest
Nov 1st, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Dim previousRow As Long
  2. Sub ListItemSelect()
  3. sched = Application.WorksheetFunction.CountA(Range("cc2:cc17"))
  4. previousRow = 2
  5.     For previousRow = 2 To sched + 1
  6.         ActiveSheet.Cells(2, 1) = ActiveSheet.Cells(previousRow, 81)
  7.         ActiveSheet.Cells(3, 1) = ActiveSheet.Cells(previousRow, 82)
  8.         ActiveSheet.Range("CJ" & previousRow & ":FJ" & previousRow).Value = ActiveSheet.Range("T18:CT18").Value
  9.     Next
  10.     previousRow = previousRow + 1
  11. ActiveSheet.Range("CJ2:FJ" & sched + 1).Copy
  12. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement