+ Reply to Thread
Results 1 to 4 of 4

Macro to hide rows with zero values

Hybrid View

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    5

    Angry Macro to hide rows with zero values

    I am obviously a VBA newbie and have been trying several macros from this site to hide my rows with zero balances.

    I have information in columns A-E and then in columns G-BE I have values, many of which are zero. I wish to hide the rows that contain zeros for values in columns G-BE. A few of the columns are empty (have no values) and some have values, including the zeros. The values start at G11 through BE2614.

    Any help much appreciated! Please let me know what other information you need.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Macro to hide rows with zero values

    a sample of file

  3. #3
    Registered User
    Join Date
    07-26-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Macro to hide rows with zero values

    The original spreadsheet has many f9 forumlas so I copy/pasted the values - so this is the sheet wihtout alm my forumalas.
    Last edited by vaciaravino; 07-26-2012 at 05:09 PM.

  4. #4
    Forum Contributor
    Join Date
    07-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    351

    Re: Macro to hide rows with zero values

    I may be misunderstanding you, but rather than writing a macro, it'd probably be easier to just add a sort filter to the columns on your spreadsheet, then de-select blanks and/or $0.00. If you really want to, you could just record yourself a macro to do this sort with a button or keyboard shortcut. Just hit record macro, click the filter button on the column you want that has the blanks, de-select 'blanks,' (and/or $0.00), and hit stop recording. Assign a keyboard shortcut or create a button, your choice. It sounds like excel already has a built-in fix for your problem so I don't really see the point of writing code (that's just me though), you can quicken the process by recording a macro to shorten the process to 1 click with a little messing around

+ 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