I want to trap an error I get in a macro

M

Mary

Hello,

I am trying to show some values using msgbox after using FIND. But when I
try to find a value that does not exist in the sheet I get an error:
Run_time: "91"


h = InputBox("Type number of holes to find")

For X = 1 To h

np = InputBox("type the name of the hole:")

Cells.Find(What:=np, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate

N = ActiveCell
L = ActiveCell.Offset(0, 1)
S = ActiveCell.Offset(0, 2)

MsgBox ("Pozo:" & " " & N & " " & "Linea:" & " " & L & " " &
"Serial:" & " " & S)

End If

Next

How can I trap this run-time error?

Thanks
 
L

lcifers

Mary,

You should google "On Error Resume Next" and "On Error GoTo". I think
this is what you're looking for.

Regards,
 
B

Bob Phillips

h = InputBox("Type number of holes to find")

For X = 1 To h

np = InputBox("type the name of the hole:")

Set Cell = Cells.Find(What:=np, _
After:=ActiveCell, _
LookIn:=xlFormulas, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False)
If Not Cell Is Nothing Then
N = Cell.Value
L = Cell.Offset(0, 1).Value
S = Cell.Offset(0, 2).Value

MsgBox ("Pozo:" & " " & N & " " & "Linea:" & _
" " & L & " " & "Serial:" & " " & S)
End If

Next


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top