Trapping a NO FIND after a find
I use the code below to store a row number to a variable after a find.
I would like to trap a NO FIND if the find is unsuccessfull
Any ideas. FSt1 provided the code below
Sub macfindrow()
dim rn as string
dim rng as range
dim therow as long
rn = inputbox("enter something to find")
if rn < "" then
Set rng = nothing
Set rng = range("A1:IV65536").Find(what:=rn, _
After:=Range("A1"), _
Lookin:=xlformulas, _
Lookat:=xlpart, _
SearchOrder:=xlbyrows, _
SearchDirection:=xlNext, _
MatchCase:=false)
end if
therow = rng.row
msgbox "Found at cell " & rng.address
msbbox "The row number is " & therow
end sub
|