Does Sheet Exist-VBForums
Results 1 to 4 of 4

Thread: Does Sheet Exist

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2012
    Posts
    12

    Does Sheet Exist

    I have the attached code that is giving me trouble; this is part of a much larger macro. It will execute one part of the If/Then, depending on if I use an = or > sign. I want the macro to look for a worksheet called "Error Summary", there will only ever be one if it does exist, if it does not exist I want it to simply create a the Then portion.

    Any assistance is greatly appreciated.
    Attached Files Attached Files

  2. #2

    Thread Starter
    New Member
    Join Date
    Dec 2012
    Posts
    12

    Re: Excel VBA - Does Sheet Exist

    I meant the 'Else' portion

  3. #3

    Thread Starter
    New Member
    Join Date
    Dec 2012
    Posts
    12

    Re: Excel VBA - Does Sheet Exist

    Disregard, I have discovered the error of my ways.

  4. #4
    Super Moderator Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    11,925

    Re: Does Sheet Exist

    Moved from "Does Sheet Exist" into it's own thread.

    Welcome to the forums Jrocket

    You may want to post what you discovered so that others could benefit from it?
    The poster formerly known as koolsid
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved

    Microsoft MVP: 2011 - Till Date IMP Links : Acceptable Use Policy, FAQ

    MyGear:
    Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.