View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Omar[_7_] Omar[_7_] is offline
external usenet poster
 
Posts: 7
Default 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