+ Reply to Thread
Results 1 to 5 of 5

Set variable shows runtime error 91 when using found item

Hybrid View

JackDoor Set variable shows runtime... 01-07-2022, 05:03 AM
romperstomper Re: Set variable shows... 01-07-2022, 05:06 AM
JackDoor Re: Set variable shows... 01-07-2022, 05:29 AM
romperstomper Re: Set variable shows... 01-07-2022, 05:39 AM
JackDoor Re: Set variable shows... 01-11-2022, 04:59 AM
  1. #1
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,974

    Re: Set variable shows runtime error 91 when using found item

    As I said, all the optional parameters persist. So if you had run another find, either manually or in code, that used a parameter that wouldn't match your current search (eg matchcase), it would stop your find from working.
    Everyone who confuses correlation and causation ends up dead.

  2. #2
    Registered User
    Join Date
    01-06-2022
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Set variable shows runtime error 91 when using found item

    Hello, All is well with the spreadsheet, the additional terms in the Find have made it work nicely.
    After watching some more videos on the subject, I see what you mean. I thought as I was only using the find function for locating the date in a single table it would have worked.

    Again, thank you for helping.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Public variable and Runtime error 91: Object Variable or With block variable not set
    By Frank Nunez in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-31-2020, 04:02 PM
  2. Runtime Error 76 - Path not Found
    By elisas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2018, 10:11 AM
  3. runtime error '-2147024809 (80070057)' The item with the specified name wasn't found
    By jigarrathod in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-05-2017, 09:18 PM
  4. Runtime error '53': File not found
    By blindbeggar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2016, 04:09 AM
  5. If Runtime error Shows up then Give a Msgbox (for userform)
    By ohboyherewegoagain in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2014, 09:20 AM
  6. [SOLVED] Variable not found & Runtime error 13
    By DJvdW in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2013, 08:17 AM
  7. Replies: 1
    Last Post: 11-17-2012, 11:10 PM

Tags for this Thread

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