[Solved] How to create a excel VBA loop to print text(“x”) in cell A5,B4,C3,D2,E1

Question

Here’s one way you can do this with a loop:

Sub x()
    Dim i As Long
    For i = 1 To 5
        Cells(6 - i, i).Value = "x"
    Next i
End Sub

Accepted Answer

Here’s one way you can do this with a loop:

Sub x()
    Dim i As Long
    For i = 1 To 5
        Cells(6 - i, i).Value = "x"
    Next i
End Sub