How to go to the first line where the cell contains certain text

Question

I have a spreadsheet where I found code that jumps to the first empty line:

lastRowA = Range("A" & Rows.Count).End(xlUp).Row + 1 ActiveWorkbook.Worksheets("RO input sheet").Range("A" & lastRowA).Select 

My problem is that the conditions surrounding the spreadsheet have changed, so now I need to configure the code to go to the first line, where cell A contains certain text, for example, "Test123".

How to do it in VBA?

Answer 1

Replace all the code simply:

 ActiveWorkbook.Worksheets("RO input sheet").Columns(1).Find("Test123").Select