Hiding row if column sum value equals 0

[drakaz]

Hi,

I have searched few topics, all had something similar but it didn't seem to work for me. I need to say I have no idea of VBA code, I only realize that if I need it running all the time I need to add it through worksheet code and if I want a button thorugh a module.

So idea is as mentioned in the topic, I want to hide a row if column value, for ex. "I.3.Change in receivables after one year" sum C5:K5 equals 0.
I added and example, but it contains numbers only, original file has only fomulas, so if value would become non-zero it should be visable again.

If anyone could help me with this it would be great.

Regards,
drakaz

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[abduljaleel.mca]

you can use this attached macro

[drakaz]

Does this help?

Please Login or Register  to view this content.

I'm not sure if code isn't working or I'm doing something wrong, as nothing happens when I add it through "View Code". I tried it with macro, it's the same as code below - doesn't unhide rows when column sum isn't 0 anymore.

[drakaz]

you can use this attached macro

Macro works one way, it hides the rows, but doesn't unhide them when they are not 0 anymore. If unhide would work that would be perfect even with a macro.

[abduljaleel.mca]

I have checked the macro, it works in both the way. Please check it again.
*Make sure that you are passing values from another sheet for these cells.

[drakaz]

Ok, I see it now. But it is not possible to make it work if data is in the same sheet?
OK, not sure what changed but now it works even with values in the same sheet. Thanks a million!

[abduljaleel.mca]

Not a problem, you can work on the same sheet itself.

[drakaz]

Is there a way I could limit that macro would work only in certain cells, for ex. C8:K12?

[abduljaleel.mca]

Attached file will work only for the range 'C8:K12'.
Need to change the 'for loop' as per your desire cells.

[drakaz]

Thanks again, marking this topic as Solved