Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the code below I get message "Subscript out of range Runtime Error 9"
I think it's to do with the asterisked line, not too sure. The only worksheets I have are "J" AND "J2" 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Message "Subscript our of range" | Excel Discussion (Misc queries) | |||
Runtime Error "1004" Select Method of Range Class Failed | Excel Programming | |||
strange "subscript out of range" error! | Excel Programming | |||
SaveAs "subscript out of range" error (COM - SOAP) | Excel Programming | |||
SaveAs "subscript out of range" error (COM - SOAP) | Excel Programming |