+ Reply to Thread
Results 1 to 3 of 3

If-Then-Else

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    75

    If-Then-Else

    Ok...getting a little bit frustrated with this, mainly because i thought i knew what i was doing!!!

    I have the code below...

    Please Login or Register  to view this content.
    But it keeps coming back with an End If without block if but I dont understand why?!?!

    Please help!

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: If-Then-Else

    Please Login or Register  to view this content.
    Break the Line after the THEN
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: If-Then-Else

    or just remove the 'end if' line ;-)

    there are two forms of If statement
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    the parts in [] are optional
    Last edited by JosephP; 06-03-2013 at 10:13 AM.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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