ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,731
- Office Version
- 2007
- Platform
- Windows
I have this code in use.
When i run he code the Input field opens & i enter a row number,selct OK
I am then taken to that row.
The code selects all that row,
How do it have the code select the cell that is in column B of that row
When i run he code the Input field opens & i enter a row number,selct OK
I am then taken to that row.
The code selects all that row,
How do it have the code select the cell that is in column B of that row
VBA Code:
Private Sub GoToRow_Click()
Dim lnRow As Long
lnRow = InputBox("ENTER ROW NUMBER.", "GO TO ROW NUMBER")
Rows(lnRow & ":" & lnRow).Select
End Sub