View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HSalim[MVP] HSalim[MVP] is offline
external usenet poster
 
Posts: 70
Default Runtime Error 91


Hi
I am trying to use the Find method in Excel (2003)

I have appended a code snippet below, which works fine if the value can be
found in a cell. If that value is not found, Excel returns a runtime error.
Any ideas why this might be so?

Regards
Habib

----------------------

Range("E" & F & ":E" & L).Select
FrstRow = Selection.Find(What:="CIB", LookIn:=xlValues, LookAt _
:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False)