+ Reply to Thread
Results 1 to 4 of 4

Macro to Hide rows with zeros in column E5:E50, then Unhide all rows

  1. #1
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Macro to Hide rows with zeros in column E5:E50, then Unhide all rows

    Need help with a macro that will hide rows that have a zero in column E5:E50. The values will be linked and change a lot so the unhide all rows will need to also be included. If there is any one that can help me with this macro it would be greatly appreciated. I have attached an example sheet with the hide zeros button and the unhide all rows button.
    Look forward to someone helping me make this possible.
    Thank you much
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to Hide rows with zeros in column E5:E50, then Unhide all rows

    Try this
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Contributor
    Join Date
    09-11-2012
    Location
    minot, north dakota
    MS-Off Ver
    Excel 2010
    Posts
    118

    Re: Macro to Hide rows with zeros in column E5:E50, then Unhide all rows

    Thank you for your help this is prefect
    You are amazing

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro to Hide rows with zeros in column E5:E50, then Unhide all rows

    You're welcome. Glad I can offer some help.

+ 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] Macro to unhide & hide rows based on column value
    By qvfr034 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-15-2020, 03:00 PM
  2. [SOLVED] Macro for Hide & Unhide the rows upto a certain column
    By Neilesh Kumar in forum Excel General
    Replies: 11
    Last Post: 09-14-2017, 10:08 AM
  3. [SOLVED] Macro for Hide blank rows and Unhide the rows with cells
    By Neilesh Kumar in forum Excel General
    Replies: 4
    Last Post: 04-12-2017, 06:06 AM
  4. Macro to Hide/Unhide rows with a strikethrough format in a cell in column A.
    By intern91 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 05:44 AM
  5. [SOLVED] VBA macro that hide and unhide column to respective rows based on first column value
    By janine6192 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2013, 06:21 PM
  6. Macro to Hide/Unhide Rows Based on Results in Column Equation
    By jwhite0720 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 04:59 PM
  7. Macro to Hide and Unhide Rows but still be able to insert rows
    By majasmi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2011, 09: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