Hello all

I have been searching for hours and tried many codes (copying, pasting and manipulating to my requirements) but I am just not that good at it, so have not been successful and would really love some help please.

Within my workbook on Sheet 60 "RESULT LINE GRAPHS" I have formulae to return calculations from 59 other sheets, which in turn feeds line graphs. I want to prevent an item with "0" showing on the graphs and I've discovered that I can achieve this by hiding the corresponding row.

So, if a value in cells E7:E12 and E40:E98 returns any value >0 I would like the corresponding row to be automatically unhidden (for example, E7 = value >0 Then Row 7 Visible - just the corresponding row in each case). Also, if this value changes back to "0" I would like the row to be automatically hidden again. I will start with all rows hidden.

In my mind this is simple, but I just can't do it.

Kindest regards to all