+ Reply to Thread
Results 1 to 4 of 4

Hidding rows based on cell value

  1. #1
    Registered User
    Join Date
    05-24-2021
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    20

    Hidding rows based on cell value

    Hi

    I have two constant values (6 is start row and 50 is end row) and one variable value in cell A1 which is for example (23).

    What is easiest way to unhide all rows between 6 and A1(23) and hide other rows between A1(23+1):50 ?

    Thanks in advanced

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    453

    Re: Hidding rows based on cell value

    Usually, I insert a column. Put 'Hide' in what cells you want hidden. Then filter the data and show BLANKS (uncheck 'Hide').....then when you want them all back, show all or check both Blanks & Hide. the filter is on the data tab.

  3. #3
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,557

    Re: Hidding rows based on cell value

    Hi nikobelic1,

    If you're looking for VBA, try below code ...
    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  4. #4
    Registered User
    Join Date
    03-21-2020
    Location
    Southwest
    MS-Off Ver
    365
    Posts
    1

    Re: Hidding rows based on cell value

    Quote Originally Posted by queuesef View Post
    Usually, I insert a column. Put 'Hide' in what cells you want hidden. Then filter the data and show BLANKS (uncheck 'Hide').....then when you want them all back, show all or check both Blanks & Hide. the filter is on the data tab.
    This is very clever and useful...thanks

+ 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] Help to fix macro: hidding multiple rows
    By ricdamiani in forum Excel Programming / VBA / Macros
    Replies: 67
    Last Post: 04-29-2019, 07:59 AM
  2. [SOLVED] Hidding Columns based on Cell Value
    By Rahul15292000 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2018, 03:11 PM
  3. Hidding/unhidding rows
    By lazareth1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-09-2016, 06:17 AM
  4. [SOLVED] Hidding rows by using VBA
    By crimzon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-18-2014, 12:53 AM
  5. Hidding Unused Rows based on column value
    By mashley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2010, 01:51 PM
  6. hidding rows with checkboxes and coping visible rows to another sheet
    By aviflux in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2008, 09:35 AM
  7. Hidding Rows
    By Sam I Am in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2007, 07:16 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