Results 1 to 12 of 12

How to code the selection.find not to crash when the data to find is blank

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-12-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    275

    How to code the selection.find not to crash when the data to find is blank

    Hi all

    What must the coding be not to recieve the "runtime error 91" when the value to find is not to be found.

    The value is spesified in a cell and in vba stored in a register (dim value as string). As long as the value exist in the search range it works but as soon as the value is not present i get the error.

    The (on error goto...) works but I would like to avoid the error from the start.
    Last edited by evertjvr; 05-23-2012 at 08:24 AM. Reason: Unable to open a thread on the PC and unable to unmark the Solved on the tablet.

Thread Information

Users Browsing this Thread

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

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