VB Code to Select Next Empty Row If Row of ActiveCell Has Value

[Stonesteel]

Greetings!

May I ask what vbcode should I use to move down to the next empty row if the current row has already a value? for example, Rows 1-3 had values already, it will move to Row 4 which is empty. Something like,

If Row 1 (with 10 Columns) has value then move to Row 2 but
If Row 2 (with 10 Columns) has value then move to Row 3 but
If Row 3 (with 10 Columns) has value then move to Row 4, if empty then
Fill Row 4 with data (with 10 Columns), then move to Row 5 to fill data (with 10 Columns) again.

 

[VoG]

Try like this

Range("A" & Rows.Count).End(xlUp).Offset(1).Select

 

[Sektor]

Sub GoToNextEmptyRow()

    Dim rngEmpty As Range
    
    ' Say, A1:J15 has data
    Set rngEmpty = Range("A1").End(xlDown).Offset(1)

End Sub

 

[Stonesteel]

Thank you for the help guys. You really are awesome.