+ Reply to Thread
Results 1 to 4 of 4

Hide rows basis specific text in cells

  1. #1
    Forum Contributor
    Join Date
    07-19-2017
    Location
    Mumbai
    MS-Off Ver
    2013
    Posts
    305

    Hide rows basis specific text in cells

    Dear Excel Experts,
    We have worksheet for 5 Whys Analysis, in which our requirement is…
    All rows with text Hide are to be hidden just after making changes in B29 i.e. Root Cause (Counter Measure).
    Please help
    Thanks in advance.

    RavindraK
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Hide rows basis specific text in cells

    Give this a try...

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    07-19-2017
    Location
    Mumbai
    MS-Off Ver
    2013
    Posts
    305

    Re: Hide rows basis specific text in cells

    Thanks a lot boss,
    It's done, you are charm !!
    RavindraK

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Hide rows basis specific text in cells

    .........................................
    Thanks.gif

+ 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. Macro to hide rows with 0 value in specific cells
    By Maike in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2016, 10:32 AM
  2. Need to hide & unhide rows basis their formula drive value ( Zero Vs Non Zero )
    By raghav.bhola in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2014, 05:43 AM
  3. [SOLVED] Enhance existing code to hide rows between specific text
    By MissaLissa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-24-2014, 03:20 PM
  4. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  5. Trying to make macro hide row if cells contain specific text
    By Chris0204 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-13-2012, 04:14 AM
  6. How to create a macro to hide specific rows where 1st column contains merged cells
    By ascottbag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2011, 01:16 PM
  7. using VBA to hide columns and rows that do not have cells with a specific format
    By fecurtis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2008, 05:47 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