Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "bypass" run-time error '91'????
The following is part of a macro that will generate the following error
message: "Run-time error '91': Object variable or With block variable not set I run this macro on an imported XML datatable that may or may not have a particular dataset (see macro below). Since it's okay if this dataset is missing (i.e., some projects may or may not have this information - if not, then this dataset will be missing entirely), what can be done to "bypass" this error statement? Cells.Find(What:="/PROJECT/ISSUES/ISSUE/FOLLOWUP/ACTUAL_DATE", After:= _ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to "bypass" run-time error '91'????
dim rng as Range
set rng = Cells.Find(What:="/PROJECT/ISSUES/ISSUE/FOLLOWUP/ACTUAL_DATE", After:= _ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False) if not rng is nothing then rng.Activate else msgbox "Missing dataset" End if -- Regards, Tom Ogilvy "Jeff" wrote in message oups.com... The following is part of a macro that will generate the following error message: "Run-time error '91': Object variable or With block variable not set I run this macro on an imported XML datatable that may or may not have a particular dataset (see macro below). Since it's okay if this dataset is missing (i.e., some projects may or may not have this information - if not, then this dataset will be missing entirely), what can be done to "bypass" this error statement? Cells.Find(What:="/PROJECT/ISSUES/ISSUE/FOLLOWUP/ACTUAL_DATE", After:= _ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) | |||
can I bypass "Windows has encountered a problem" | Excel Discussion (Misc queries) | |||
Bypass "DISable Macros" | Excel Programming | |||
"Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming | |||
"Can't Show Modally" - Run-Time Error '400' Problem | Excel Programming |