Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"On Error" help required
Dear Friends,
In the code given below if there is no error then also the msg box is displayed. Any help please. Sub Macro1() Dim Thyag On Error GoTo Thyagaraj_Not_Found Cells.Find(What:="Thyagaraj", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False).Activate With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid Thyagaraj_Not_Found: 'Selection.Font.Bold = True Thyag = MsgBox("Thyagaraj not found") End With End Sub Thanks in Advance Thyagaraj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
error while compiling "OBJECT REQUIRED" | Excel Discussion (Misc queries) | |||
Getting "Object Required" Error Message - Need Help !!! | Excel Programming |