[Solved] Simple VBA code to open cells one after the other

by


Why would you want to do this? VBA doesn’t have a keyword that represents entering into a cell. You can select the cell like this though:

Sub DoNotRun()
    Dim rng as range
    For Each rng In ThisWorkbook.Worksheets("Sheet1").range("A:A")
        rng.Select
    Next rng
End Sub

If you really need to simulate a double click — Worksheets have a _BeforeDoubleClick event that might help

1

solved Simple VBA code to open cells one after the other