+ Reply to Thread
Results 1 to 5 of 5

Unable to get the FindNext property of the Range Class

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    59

    Unable to get the FindNext property of the Range Class

    I keep getting that error when I'm running my macro. When I debug, it points me to the bolded line in the code below.

    The larger macro I'm running this function in runs this function some 101 times without error before this happens.

    The values of the parameters are as follows when it gives me the error:
    Find_Exact("hchen", ws1, "B:B")

    The first parameter is the only one that changes in the previously mentioned running of this function.

    Please Login or Register  to view this content.
    What could possibly be the problem??

    Thanks for the help.
    Last edited by Kaigi; 06-26-2009 at 04:05 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Unable to get the FindNext property of the Range Class

    Maybe this:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-03-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    59

    Re: Unable to get the FindNext property of the Range Class

    Oh - that looks much simpler. Does xlWhole guarantee that cell1.value = cell2.value?

    What does search_format specify?

    Thanks

  4. #4
    Registered User
    Join Date
    06-03-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    59

    Re: Unable to get the FindNext property of the Range Class

    Ok I made a small test program to find out if xlwhole would work for what I wanted it for and it's good I think.

    That ended up being simple

    Thanks for the help!

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Unable to get the FindNext property of the Range Class

    Does xlWhole guarantee that cell1.value = cell2.value? What does search_format specify?
    Help is your friend.

+ 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