+ Reply to Thread
Results 1 to 1 of 1

excel find error

  1. #1
    Registered User
    Join Date
    01-10-2005
    Posts
    4

    runtime error 91"

    Hi
    On
    Cells.Find(What:="XYZ:", After:=ActiveCell, LookIn:= _
    xlValues, LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:= _
    xlNext, MatchCase:=False).Activate

    On completion of finding this data in the sheet.
    It finds all the occurrences ( in this case 20) and at the last one it pops up an error
    "runtime error 91"
    "Object variable or with block variable not set error."

    Can you tell me how it can be fixed.
    ThankYou
    Last edited by rk03; 01-10-2005 at 04:39 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1