Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What happens if find fails (2000)

    Please find below my code. I needed to include the if statement to take account of the possibility that the "adjusted rates" text might not be on the sheet. Excel VBA help states that the formula "Returns Nothing if no match is found. Doesn

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: What happens if find fails (2000)

    Try "Is "Nothing" instead of "= Nothing". Nothing is not an ordinary value like 37 or "liitle green apples", so you can't use = to compare a value to nothing.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What happens if find fails (2000)

    Hans

    Thanks very much. It seems to work now.

    Alex

Posting Permissions

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