Loop to specific rows
I am tying the following, but it doesn't seem to work
Range("B7").Select
For i = 0 To 10
For j = 0 To 6
ActiveCell.Offset(i * 5, j).Select
Selection.Copy
Windows("Test.xls").Activate
ActiveCell.Range("A2").Select
ActiveSheet.Paste
Next j
Next i
|