+ Reply to Thread
Results 1 to 10 of 10

Macro to hide (or group) rows if value if zero

  1. #1
    Registered User
    Join Date
    11-03-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    29

    Macro to hide (or group) rows if value if zero

    I need a macro to hide (or to group and collapse) the rows that has zero value in two particular columns adjunct to the row. Please see the attachment for details. Appreciate your kind assistance. Cheers!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to hide (or group) rows if value if zero

    Trt this one
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-03-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Macro to hide (or group) rows if value if zero

    Thanks for the reply, AB33! This macro seems to hide rows that has value in column F as well. I need to hide rows that have zero value in both column D & F. Can you assist please? Thanks a million! Cheers!

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to hide (or group) rows if value if zero

    Bernard!
    I have tried this code, but it does not seem to work. Perhaps, more able people could spot my error

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to hide (or group) rows if value if zero

    Bernard!

    I have tried this code, but it does not seem to work. Perhaps, more able people could spot my error.

    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to hide (or group) rows if value if zero

    I have got this one from on-line and adjusted it to your needs. See if this one works

    Please Login or Register  to view this content.

  7. #7
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to hide (or group) rows if value if zero

    This one seems to work

    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to hide (or group) rows if value if zero

    I have now corrected my earlier code and this one also seems to work.
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    11-03-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Macro to hide (or group) rows if value if zero

    Thanks AB33. It works perfectly. Have a great weekend ahead! Cheer!

  10. #10
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to hide (or group) rows if value if zero

    Glad to know it worked for you!
    Like you, I am a learner, picking up few things as I go and hopefully to get better by a day. The moderators may ask you to close this thread if you are happy with the solution.

+ 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