+ Reply to Thread
Results 1 to 3 of 3

How do I combine several hide and unhide statements

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    Charlotte NC
    MS-Off Ver
    Excel 2007
    Posts
    31

    How do I combine several hide and unhide statements

    There is a series of questions and based on the answer the users selects, certain rows need to unhide or hide so the user can continue to answer more questions.

    I think I need to use Case but I cannot make it work

    Example:
    If C10 = X then unhide rows 13-15
    If C11 = X then Unhide rows 124-169

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: How do I combine several hide and unhide statements

    Maybe like this :

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Registered User
    Join Date
    04-24-2013
    Location
    Charlotte NC
    MS-Off Ver
    Excel 2007
    Posts
    31

    Re: How do I combine several hide and unhide statements

    Thank You very much I will make the changes you have suggested.

+ 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. [SOLVED] Hide And Unhide Column With One Button,,,,Once Click Hide,,,,,Again Click Unhide
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2014, 07:58 AM
  2. Hide / Unhide
    By zachdking in forum Excel General
    Replies: 1
    Last Post: 10-28-2013, 02:10 AM
  3. Hide With No Value, Unhide All
    By ando185 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2013, 12:15 PM
  4. Hide/Unhide
    By jknober in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2010, 05:06 PM
  5. Hide/Unhide
    By mcmuney in forum Excel General
    Replies: 3
    Last Post: 06-16-2009, 09:04 PM

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