For next loops i EXCEL

Fornybar energy opgave:

Sub capacity5()

Dim i, j As Integer

For j = 2 To 16

    For i = 5 To 39

        If Worksheets("Capacity").Cells(i, j).Value <> Worksheets("Capacity revised").Cells(i, j).Value Then
   
        Worksheets("Capacity").Cells(i, j).Font.Bold = True
   
        End If
   
        Next i
   
Next j

End Sub

Loope gennem rækker og koloner.

Sub Macro1()
'
' Macro1 Macro

Dim i, j As Integer

For j = 4 To 6
    For i = 5 To 24
   
    If Cells(i, j).Value <> 0 Then
   
    Cells(2, j).Value = Cells(i, 3).Value
    Cells(3, j).Value = Cells(i, j).Address
   
    i = 24
    End If
   
    Next i
Next j

End Sub

.... og spørgsmålet er ???

Sorry.