+ Reply to Thread
Results 1 to 5 of 5

Hide and Unhide base on blank cell in range

  1. #1
    Registered User
    Join Date
    05-24-2014
    Location
    Bratislava, Slovakia
    MS-Off Ver
    2007
    Posts
    11

    Hide and Unhide base on blank cell in range

    Hi

    I need to hide rows, which cell don't have any value in range (month). See attachment.
    Yellow rows should be hidden.

    Thanks

    Hide blank rows.xlsx

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Hide and Unhide base on blank cell in range

    Try this..

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Hide and Unhide base on blank cell in range

    Hello
    For the 'Hide' button try:

    Please Login or Register  to view this content.
    Hope this helps.
    DBY

    And the 'Unhide':

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-24-2014
    Location
    Bratislava, Slovakia
    MS-Off Ver
    2007
    Posts
    11

    Re: Hide and Unhide base on blank cell in range

    Thank you

    It works.

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hide and Unhide base on blank cell in range

    Hello kepasso,

    Since you have stated;

    ...Yellow rows should be hidden.
    I was about to suggest the following:

    Please Login or Register  to view this content.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ 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] Unhide/Hide Sheet if any cell value in a range is YES
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2015, 05:07 PM
  2. [SOLVED] macro to hide rows if cell is blank, unhide if it contains text
    By Russ Fuquay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2013, 10:02 PM
  3. Automatically hide columns and unhide of cell value(s) appear within a range
    By oddinho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2013, 08:32 PM
  4. [SOLVED] Please help with this monster! Need help w/VBA codes to hide and unhide rows base on lists
    By SeniaHdz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-16-2013, 12:40 PM
  5. Hide or Unhide Rows base on value in row
    By playtone22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2013, 05:54 PM
  6. hide/unhide protected cell base on value
    By blacksmith in forum Excel General
    Replies: 1
    Last Post: 07-18-2012, 08:14 AM
  7. Hide/Unhide a range of rows when cell is empty
    By chuck edwards in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2012, 04:25 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