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!
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!
Trt this one
Please Login or Register to view this content.
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!
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.
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.
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.
This one seems to work
Please Login or Register to view this content.
I have now corrected my earlier code and this one also seems to work.
Please Login or Register to view this content.
Thanks AB33. It works perfectly. Have a great weekend ahead! Cheer!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks