+ Reply to Thread
Results 1 to 3 of 3

Select Case to hide rows

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2013
    Posts
    137

    Select Case to hide rows

    Hi

    I am blocked in a situation.
    I want to hide rows if they have two conditions - Col 2 must have a value (A, B, ..., G) and Col 92 must have a zero value.

    I've tried the code below but it doesn't work - It hides all rows in range with zero value in col 92 and with no value in col 2. What's missing or what's wrong in the code?

    Thanks in advance.

    Please Login or Register  to view this content.
    Last edited by ioncila; 09-23-2009 at 10:33 AM.

  2. #2
    Forum Contributor
    Join Date
    03-25-2008
    MS-Off Ver
    Excel, Outlook, Word 2007/2003
    Posts
    245

    Re: Select Case to hide rows

    Please Login or Register  to view this content.
    Charlize

  3. #3
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Porto, Portugal
    MS-Off Ver
    Excel 2013
    Posts
    137

    Re: Select Case to hide rows

    Thank You very much

    That works perfectly.

+ 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