+ Reply to Thread
Results 1 to 5 of 5

Else without If Compilation Error

  1. #1
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Else without If Compilation Error

    I'm not sure why this is throwing a compile error and telling me that I have an Else Without If. The error is on ElseIf lines. Everything else seems to be working. Any suggestions? (Sorry I posted this again in a comment when I was trying to get the formatting correctly).

    Please Login or Register  to view this content.
    I apologize for any formatting/indentation errors. I'm brand new to VBA. I searched for the answer, but everything I was finding looked like this.
    Last edited by aearce2000; 06-19-2014 at 05:46 PM.

  2. #2
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Else without If Compilation Error

    Please Login or Register  to view this content.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Else without If Compilation Error

    Download SmartIndenter from Excel MVP Stephen Bullen. When you install and run it, you'll see this:

    Please Login or Register  to view this content.
    Does that give you a clue?
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Else without If Compilation Error

    Ok, I see it now. Thank you so much!!! I'll have to download that!

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Else without If Compilation Error

    You're welcome.

+ 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. Compilation error
    By ciro8 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-21-2012, 09:03 AM
  2. compilation error
    By prajesh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-23-2011, 02:38 AM
  3. Pi = 4 * Atn(1) Compilation Error
    By gmahlert in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-08-2010, 04:10 PM
  4. VBA compilation error : expected expression error
    By raknahs in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-21-2010, 12:57 PM
  5. [SOLVED] Help please, error in compilation
    By Capt. Nemo in forum Excel General
    Replies: 1
    Last Post: 07-28-2006, 08:20 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