View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default Subscript out of range

In the code below I get message "Subscript out of range"
I think it's to do with the asterisked line, not too sure.

Sub desI()
Worksheets.Add.Name = "Changes"
k = 2
For i = 1 To 200
For j = 1 To 200
** If Worksheets("J").Cells(i, j) < Worksheets("J2").Cells(i, j) Then
Worksheets("J").Cells(i, j).EntireRow.Copy _
Destination:=Worksheets("Changes").Cells(k, 1)
Worksheets("J2").Cells(i, j).EntireRow.Copy _
Destination:=Worksheets("Changes").Cells(k + 1, 1)
With Worksheets("Changes")
.Cells(k + 1, 1).ClearContents
For m = 2 To 20
.Cells(k + 2, m).Value = .Cells(k, m) - .Cells(k + 1, m)
With .Cells(k + 2, m).borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
End With
Next m
End With
k = k + 4
Exit For
End If
Next j
Next i

End Sub