+ Reply to Thread
Results 1 to 6 of 6

hide rows -- criteria from multiple columns

  1. #1
    Registered User
    Join Date
    10-12-2012
    Location
    Karlsruhe, Germany
    MS-Off Ver
    Excel 2010
    Posts
    4

    hide rows -- criteria from multiple columns

    Hi,
    I've the following macro set up for my worksheet to automatically hide all rows, except those with "Fox" in one range (column).

    Please Login or Register  to view this content.
    However, I want to make another column at "Z4:Z500" for additionally hiding all with the criteria of "Dead" in that column. In other words, I want to hide all of the dead foxes, as well.
    Thank you for any help anybody may give me.
    n

  2. #2
    Forum Contributor
    Join Date
    10-02-2012
    Location
    Bumi Nusantara
    MS-Off Ver
    Excel 2010; Excel 2016
    Posts
    136

    Re: hide rows -- criteria from multiple columns

    try this code
    Please Login or Register  to view this content.
    click the star if it solves your problem

  3. #3
    Registered User
    Join Date
    10-12-2012
    Location
    Karlsruhe, Germany
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: hide rows -- criteria from multiple columns

    Thanks! But with that code I've got a compile error "Invalid use of property" on '.Hidden' the first instance 'rngCell.EntireRow.Hidden' (line 9). How can that be better?

  4. #4
    Registered User
    Join Date
    10-12-2012
    Location
    Karlsruhe, Germany
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: hide rows -- criteria from multiple columns

    I've got it!

    Please Login or Register  to view this content.
    Thanks!

  5. #5
    Forum Contributor
    Join Date
    10-02-2012
    Location
    Bumi Nusantara
    MS-Off Ver
    Excel 2010; Excel 2016
    Posts
    136

    Re: hide rows -- criteria from multiple columns

    try this one,
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    10-12-2012
    Location
    Karlsruhe, Germany
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: hide rows -- criteria from multiple columns

    Thank you again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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