Select a cell in column “A” based on its row number.

[harzer]

Hello everyone,
Via this message, I would like to explain my little problem to you.
I want to select a cell in column "A", based on the row number, let me explain:
How to proceed?
We ask the user to mention the number of the line concerned via an inputbox, when the user has entered the desired line, then we go to the cell in column "A" of the number of the line entered by the user .
Thank you for your contributions.

 

[bebo021999]

Like this?

Option Explicit
Sub test()
Dim ip
ip = InputBox(" Which line do you want?")
If Not IsNumeric(ip) Or ip > Rows.Count Then
    MsgBox "Invalid line number! Try again"
    Exit Sub
End If
Cells(ip, "A").Select
End Sub

 

[harzer]

Hello bebo021999,
Thanks for your response, that's exactly what I'm looking for.
The proposed code meets my expectations.
Big THANK YOU to you.