+ Reply to Thread
Results 1 to 3 of 3

Object Required error in set loop

  1. #1
    Registered User
    Join Date
    10-07-2015
    Location
    Idaho Falls, Idaho
    MS-Off Ver
    2013
    Posts
    28

    Object Required error in set loop

    I am trying to make a dynamic piece of code that takes data from one database(based on size to determine which piece of data) and places it in another sheet in a row that is determined by the last row data is on already. This breaks in the Set = Email_Database portion of the loop. Any advice?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Object Required error in set loop

    Not sure what exactly you are trying to do with that line. Try removing the "Set" as you don't need it for what I think you are trying to do. Note: You are not using the variable X anywhere, do you really need the loop
    If you are happy with my response please click the * in the lower left of my post.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Object Required error in set loop

    Set is for objects, on the problem line of code you appear to want to set the value of one cell to the value of another, try removing Set.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Simple Calendar pop up macro --> error Run-time error '424': Object required
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 10:38 AM
  2. error object required
    By anavakom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2013, 11:22 AM
  3. [SOLVED] Error 424 : Object Required
    By battenborrow in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-08-2013, 12:12 PM
  4. [SOLVED] Simple object required error in loop
    By Dunctonsteel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2013, 01:16 PM
  5. "Object required" error with VBA loop rows deleting
    By JKWIN in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2012, 09:31 AM
  6. Name.Object (Error Object Required)
    By dssrun209 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2010, 01:38 PM
  7. Error 424 Object Required Error when Using AddItem to ListBox Generated in Code
    By jclark419 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2010, 12:47 PM
  8. Object required error in a loop
    By yellephant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2007, 12:22 PM

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