+ Reply to Thread
Results 1 to 3 of 3

Runtime Error '424' - Object Required

  1. #1
    Valued Forum Contributor ffffloyd's Avatar
    Join Date
    05-20-2008
    Location
    Melbourne, VIC, Australia
    MS-Off Ver
    Office 365
    Posts
    242

    Runtime Error '424' - Object Required

    Hi guys,

    Can someone spot the obvious error? I've been looking at this for over an hour and can't see the problem.

    Please Login or Register  to view this content.
    In the above snippet, rngFind and rngSearch are both defined as Range objects and sNew is a string. The Find is successful; rngFind is populated with cell information. However, the Do Until line throws error '424', saying that an object is required. What is wrong with using a Range in this way?
    Last edited by ffffloyd; 11-02-2011 at 09:53 PM.
    _______________
    Floyd Emerson
    Data Warehousing Consultant
    Melbourne, Victoria, Australia

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: Runtime Error '424' - Object Required

    Hi Floyd,

    Perhaps try "rngFind is Nothing" instead of "..is Empty".

    I believe Empty refers to strings, while Nothing refers to objects (at a basic level).

  3. #3
    Valued Forum Contributor ffffloyd's Avatar
    Join Date
    05-20-2008
    Location
    Melbourne, VIC, Australia
    MS-Off Ver
    Office 365
    Posts
    242

    Re: Runtime Error '424' - Object Required

    D'OH! I'm such a klutz. Thank you!

+ 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