How do I write a Macro to Move cursor to next blank cell in a specific row, say row 2

[kalil]

How do I write a Macro to Move cursor to next blank cell in a specific row, say row 2

 

[kalil]

how about
Range("2" & worksheets(1).columns.count).end(xlRt).Offset(0,1).Select

 

[Alex Blakenburg]

See if one of these 2 work for you.

' Using the Active Cell
Sub NextBlankCellOnRow()

    Dim rCell As Range
    Dim ws As Worksheet
    
    Set ws = ActiveSheet
    Set rCell = ActiveCell
    
    If rCell.Offset(0, 1) = "" Then
        rCell.Offset(0, 1).Select
    Else
        rCell.End(xlToRight).Offset(0, 1).Select
    End If
    
End Sub

' Specifying the starting cell
Sub NextBlankCellOnRow_SpecifiedCell()

    Dim rCell As Range
    Dim ws As Worksheet
    
    Set ws = Worksheets(1)
    Set rCell = ws.Cells(2, "A")
    
    If rCell.Offset(0, 1) = "" Then
        rCell.Offset(0, 1).Select
    Else
        rCell.End(xlToRight).Offset(0, 1).Select
    End If
    
End Sub

 

[kalil]

Thanks Alex, u are my champion, hero and star indeed

 

[Alex Blakenburg]

You're welcome. Glad I could help.