+ Reply to Thread
Results 1 to 4 of 4

Error message on macro

  1. #1
    Registered User
    Join Date
    08-08-2011
    Location
    Alabama
    MS-Off Ver
    Excel 2003
    Posts
    6

    Error message on macro

    I've attached a workbook with a macro that seems to be working as it is supposed to, however, every time I run it, an error message pops up and I don't know what to do to fix it. The error message is -
    Run-time error '91':
    Object variable or With block variable not set

    Anyone know what I need to do to fix?

    By the way, I'm not real adept at macros so you will probably be way over my head if you get too technical with your guidance (the awesome Leith Ross wrote the macro seen here).

    Thanks!!!
    Attached Files Attached Files
    Last edited by zmbd; 08-10-2011 at 06:32 PM.

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,282

    Re: Error message on macro

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-08-2011
    Location
    Alabama
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Error message on macro

    Man, you folks are good. This stuff looks like Greek to me. It seems to be working perfectly now.

  4. #4
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,282

    Re: Error message on macro

    The problem was caused by an empty sheet, so the word Partner got added to the check list (which should have been just initials). I just added a check that the last row of the search range was greater than the row 9 (your start point), therefore avoiding that situation. The rest is pure Leith

+ 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