+ Reply to Thread
Results 1 to 3 of 3

Error: End Select without Select Case

  1. #1
    Registered User
    Join Date
    04-22-2012
    Location
    Syracuse, NY, USA
    MS-Off Ver
    Office 365
    Posts
    61

    Error: End Select without Select Case

    On debug I am receiving the error named in the title of this post. I cannot see why. When I look back at the code it sends me to this function.
    Please Login or Register  to view this content.
    And just for completions sake (and because the previous code references it):
    Please Login or Register  to view this content.
    Reality is stranger than fiction.

  2. #2
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Error: End Select without Select Case

    Hi,

    You are missing an "End if" in Case 5.

    edit: you can make the code shorter if you want by writing the if-then structures in the same row. That way you don't need to use End If. Something like this:
    Please Login or Register  to view this content.
    Last edited by RHCPgergo; 11-28-2012 at 12:20 PM. Reason: addtitional info

  3. #3
    Registered User
    Join Date
    04-22-2012
    Location
    Syracuse, NY, USA
    MS-Off Ver
    Office 365
    Posts
    61

    Re: Error: End Select without Select Case

    u_u' Sometimes it's the little things that are missed. tyvm.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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