+ Reply to Thread
Results 1 to 8 of 8

End if without block if

  1. #1
    Registered User
    Join Date
    07-12-2010
    Location
    inda
    MS-Off Ver
    Excel 2003
    Posts
    27

    End if without block if

    Can someone throw me some light on why the below code is giving me an error? i'm new to macros and having trouble with the syntax.

    Error: End if without block if
    Please Login or Register  to view this content.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: End if without block if

    You need:
    Please Login or Register  to view this content.
    before your End If line.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: End if without block if

    snb, this forum can work just fine without snide remarks like yours.

    deleted.

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: End if without block if

    Studying a good book on VBA is the best advice you can offer in a forum. Please look at all my other suggestions (and how they are appreciated) before you misinterpret what was meant as a sound advice.

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: End if without block if

    Then why not just offer the same advice to pretty much everyone?

  6. #6
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: End if without block if

    snb, if you really want to be helpful, you can offer a few titles, rather than a general "rtfm" approach.

  7. #7
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: End if without block if

    If the OP is interested I will, but only if requested.

  8. #8
    Registered User
    Join Date
    07-12-2010
    Location
    inda
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: End if without block if

    Thanks for the answer romper.

+ 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