Results 1 to 18 of 18

Simpler way than 11+ If Statements?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    Simpler way than 11+ If Statements?

    Hi
    I have a worksheet change event that looks at a range of 11 cells
    If any of those changed, then there are 11 If/Else statements under it to either hide or unhide rows on a different tab.
    My question is, do I have to do this 11 times or is there a cleaner/better way?
    I've named all the various ranges in a similar fashion.

            
    
            If Sheet2.Range("s8_yn01") = "N" Then
                If Sheet8.Range("s8_g01").EntireRow.Hidden = False Then
                    Sheet8.Range("s8_g01").EntireRow.Hidden = True
                    Sheet1.Range("s8_v01") = 1 'hidden
                End If
            Else
                If Sheet8.Range("s8_g01").EntireRow.Hidden = True Then
                    Sheet8.Range("s8_g01").EntireRow.Hidden = False
                    Sheet1.Range("s8_v01") = 0 'unhidden
                End If
            End If
    
            If Sheet2.Range("s8_yn02") = "N" Then
                If Sheet8.Range("s8_g02").EntireRow.Hidden = False Then
                    Sheet8.Range("s8_g02").EntireRow.Hidden = True
                    Sheet1.Range("s8_v02") = 1 'hidden
                End If
            Else
                If Sheet8.Range("s8_g02").EntireRow.Hidden = True Then
                    Sheet8.Range("s8_g02").EntireRow.Hidden = False
                    Sheet1.Range("s8_v02") = 0 'unhidden
                End If
            End If
    Last edited by ker9; 08-28-2015 at 04:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 09-29-2013, 04:50 AM
  2. Help make this simpler (if statements)
    By harmbasi in forum Excel General
    Replies: 3
    Last Post: 04-13-2012, 02:58 PM
  3. IF STATEMENT - must be a simpler way
    By tlapointe1970 in forum Excel General
    Replies: 1
    Last Post: 07-26-2011, 05:01 PM
  4. A simpler way to do nested vlookups?
    By bsoper in forum Excel General
    Replies: 4
    Last Post: 01-06-2011, 03:43 PM
  5. Creating Simpler Macro
    By d4ftpuNK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2009, 02:04 AM
  6. is there not a simpler way
    By T.c.Goosen1977 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2006, 03:55 AM
  7. Complex formula vs. simpler
    By GerryK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2005, 11:35 AM
  8. How can I make this simpler?
    By Sethaholic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2005, 04:05 PM

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