Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My "On Error goto" isn't working.
The following is a simple search. The search doesn't find the desired "2" so it should go to EEERRR, but it doesn't; it gives an error message: "Object variable or With block variable not set". Any clue as to what that error message means? Sub test2() On error goto EEERRR CCC = 2 Range("a10").Select Cells.Find(What:=CCC, After:=ActiveCell, LookIn:= _ xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _ xlNext, MatchCase:=False).Select EEERRR: 'some code here End Sub TIA! Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
On Error GoTo Doesn't Work | Excel Discussion (Misc queries) | |||
On Error GoTo | Excel Programming | |||
On Error GoTo : How to use multiple? | Excel Programming | |||
On error goto 0? | Excel Programming | |||
On error goto 0 | Excel Programming |