+ Reply to Thread
Results 1 to 3 of 3

Error 91: Object variable or With block variable not set

  1. #1
    Registered User
    Join Date
    07-03-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    3

    Error 91: Object variable or With block variable not set

    Dear friends,

    I get a message from someone who performs a test for me that message above emerges when opening my vba project. Below is the code. I'm puzzling, but can't find the solution. In my excel 2007 and 2013, the error doesnt appear. Is there anyone who can help me?
    Here's the ThisWorkbook code:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

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

    Where does the error happen?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    07-03-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2003
    Posts
    3

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

    It appears after clicking "enable editing" in Excel 2010+. That is right after shutting down the protected view.

+ 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: 6
    Last Post: 12-21-2012, 08:03 AM
  2. Replies: 1
    Last Post: 09-25-2012, 08:03 PM
  3. Object Variable or With Block Variable Not Set- Error on Another User Machine
    By dailem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2010, 09:28 AM
  4. Find Method error: -Object variable with block set variable not set
    By bambino_32 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-02-2010, 01:18 AM
  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

Tags for this Thread

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