+ Reply to Thread
Results 1 to 5 of 5

Hide Row if no values exist in row column X through Y

  1. #1
    Registered User
    Join Date
    03-15-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Hide Row if no values exist in row column X through Y

    I went and did a couple searches and tried to get an example I saw to work. Sadly I couldn't figure out why it wasn't functioning correctly...

    In this workbook I need to hide a row if no value exists in column C through Nth for the row, I was using http://www.excelforum.com/excel-prog...-is-empty.html as my example.

    Modified it so it worked on Sheet 19 and started at C6, but when I went to check it out nothing i could notice occured...

    testingdemo.xls

    Any way to help me get it so that the rows hide and unhide the blank rows would be extremely grateful.
    Last edited by 13reak; 03-15-2012 at 04:11 PM. Reason: solved

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Hide Row if no values exist in row column X through Y

    give this a shot:

    Please Login or Register  to view this content.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Registered User
    Join Date
    03-15-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Hide Row if no values exist in row column X through Y

    That worked pretty well DG, what exactly would need to be changed to unhide them..

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Hide Row if no values exist in row column X through Y

    the macro only does hiding, so if you highlight all rows in excel, rightclick and unhide them all, then rerun the macro it will update your hidden rows.

    or add this line to the begining of the code, to unhide everything before it runs

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-15-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Hide Row if no values exist in row column X through Y

    works for me, I'll just modify my button to do so, thanks DG

+ 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