View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_43_] Jeff[_43_] is offline
external usenet poster
 
Posts: 6
Default 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