To wrap code use / symbol not \
Also No need to select
Try
VBA Noob![]()
Sub findRowNumber() Dim Rng As Range Set Rng = ActiveSheet.UsedRange.Find(What:="104", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext) MsgBox (" The Row number of the selected cell is " & Rng.Row) End Sub
Bookmarks