+ Reply to Thread
Results 1 to 3 of 3

Worksheet: Object variable or With block variable not set?

  1. 11-28-2013, 10:55 AM #1
    Greg J.
    Greg J. is offline
    Registered User
    Join Date
    11-28-2013
    Location
    United States
    MS-Off Ver
    2013
    Posts
    3

    Question Worksheet: Object variable or With block variable not set?

    I am getting "Run-time error '91': Object variable or With block variable not set" on the marked line:

    Please Login or Register  to view this content.
    It seems that my types are right, and that oWStoSearch specifies a unique worksheet. Even so, if it wants an object for oWStoSearch to dereference, I'm not sure how to do that. What am I doing wrong?
    Last edited by Fotis1991; 11-28-2013 at 10:59 AM. Reason: Pls use code tags as per forum rules
    Reply With QuoteRegister To Reply
  2. 11-28-2013, 11:04 AM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Worksheet: Object variable or With block variable not set?

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 11-28-2013, 12:03 PM #3
    Greg J.
    Greg J. is offline
    Registered User
    Join Date
    11-28-2013
    Location
    United States
    MS-Off Ver
    2013
    Posts
    3

    Re: Worksheet: Object variable or With block variable not set?

    D'oh! Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel VBA error code 91: Object variable or with block variable not set
    By wilnexpc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2013, 11:46 AM
  2. Adding a variable string comment to a cell. "Object Variable or WIth Block Variable Not.."
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2013, 12:14 PM
  3. VBA Loop, Find & Copy run-time error '91': Object variable or With block variable not set
    By DavidBW in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-21-2012, 08:03 AM
  4. Error "Object variable or With block variable not set" returning worksheet to function
    By BenCh1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2012, 12:08 AM
  5. 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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1