+ Reply to Thread
Results 1 to 2 of 2

Need help with nested if statements

  1. #1
    Registered User
    Join Date
    02-19-2009
    Location
    Myerstown, pa
    MS-Off Ver
    Excel 2003
    Posts
    10

    Need help with nested if statements

    Need help with "if then" coding. Please look at the following macro from section starting at see below
    The first section testing n8 and b8 works fine but I also need to check several other cells that are commented out.
    Suggestions greatly appreciated.
    [email protected]


    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 09-03-2012 at 04:18 PM. Reason: Added code tags, as per forum rules. Don't forget!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Need help with nested if statements

    You have:
    Please Login or Register  to view this content.
    That End If statement goes with the second If, not the first, your If..Then..Else statement is constructed wrong:
    It should be:
    Please Login or Register  to view this content.
    also try:
    Please Login or Register  to view this content.
    Same idea:
    Please Login or Register  to view this content.
    Last edited by protonLeah; 09-03-2012 at 04:54 PM.
    Ben Van Johnson

+ 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