+ Reply to Thread
Results 1 to 7 of 7

Error 91: Object variable or With block variable not set

  1. #1
    Registered User
    Join Date
    09-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    70

    Error 91: Object variable or With block variable not set

    This was working one before, now it stoped. This is what I have
    Please Login or Register  to view this content.
    It is highlighting
    Please Login or Register  to view this content.
    What does this mean?
    Last edited by LightHeart7; 01-16-2015 at 03:11 PM.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Error 91: Object variable or With block variable not set

    What is finderV.Value?
    If the code unable to find finderV.Value then it can not loop through the range

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    70

    Re: Error 91: Object variable or With block variable not set

    Hm, well the finderV.Value only can be a value in the B column. findV is a combo box pulling from values there. so the one i tried is Tester 1, which has two sets in there. Tester 1 - New York (Column C) & Tester 1 - California (Column C). Different rows. I was just trying to get it to list both NEw York and California in this finderC but i ran into this first.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Error 91: Object variable or With block variable not set

    If the code finds finderV.Value, it will loop through column C. If nothing is found, you will not get an error, rather the code jumps in to to end if line.
    Although this also may mean nothing, but it will show you to check your data why there is no match found.

  5. #5
    Registered User
    Join Date
    09-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    70

    Re: Error 91: Object variable or With block variable not set

    Perhaps i've done something strange then. Is it possible the problem is the Column is hidden?

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Error 91: Object variable or With block variable not set

    Please attach the sample with the code. This help us to see what is going.

  7. #7
    Registered User
    Join Date
    09-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    70

    Re: Error 91: Object variable or With block variable not set

    Oddly enough it started to work again after i tried to reset something, but thank you. But I will try and make up a sample for my other question on getting it to pull all items into the listbox

+ 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. Replies: 2
    Last Post: 08-22-2014, 03:55 AM
  2. Macro issue: Object variable or with block variable not set error
    By utgjmb1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-29-2013, 06:07 AM
  3. Replies: 6
    Last Post: 12-21-2012, 08:03 AM
  4. Replies: 1
    Last Post: 09-25-2012, 08:03 PM
  5. Object variable or With block variable not set" error message
    By JoeS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-22-2009, 11:51 AM

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