Results 1 to 8 of 8

".Find" Returns Run-time error '91': if the Item Is Not Found.

Threaded View

  1. #1
    Registered User
    Join Date
    12-21-2017
    Location
    Wokingham, England
    MS-Off Ver
    office 365 2013
    Posts
    46

    ".Find" Returns Run-time error '91': if the Item Is Not Found.

    I am trying to establish whether or not a Bank Holiday date appears on a list so I can use Workday_Intl to obtain the date of the previous working day.

    I am using the code line
    BankHoliday = .Find(what:=FirstMonday, LookIn:=xlValues, LookAt:=xlWhole)
    which works fine when the search date is on the list but displays Run-time error '91': if it is not. I have to say this must take the award for being the most obscure, meaningless, and misleading error message of all time.

    What use is .Find if it cannot be used to find whether or not something is present?

    I have attached an example spreadsheet demonstrating the problem.

    Any help will be much appreciated.
    Tegglet
    Attached Files Attached Files
    Last edited by Tegglet; 10-28-2021 at 07:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] error "the file could not been found" every time i open Excel
    By MaartenRo in forum Excel General
    Replies: 2
    Last Post: 02-09-2021, 01:35 AM
  2. [SOLVED] Listbox remove item yields error: "Unspecified" run-time error '-2147467259 (80004005)':
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2016, 01:48 PM
  3. [SOLVED] Loop Creates "item not found error" on second pass
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-16-2014, 02:24 PM
  4. [SOLVED] Range.find returns "Nothing" in error, not sure of cause
    By enphynity in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-14-2013, 04:00 PM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  6. Me.Controls.Add returns "Compile error, method or data member not found"
    By mattisch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2007, 07:53 AM
  7. Run time error 1004: "No list was found.."
    By hachiroku in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2006, 07:55 AM

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