Hiding rows based on a conditional

[ryannjohnsonn]

I'm trying to properly hide rows using a macro/conditionals and I'm a bit lost on how exactly to get the macro to function for this.

Here's the layout I'm using, basically this is an "information" sheet that pulls data from other sheets in a nice uniform way.

I want rows 20-29 to be visible if any of the values in F20:F28 are >= 1 and hide them if all of the values in F20:F28 are <= 1

What's the best way to setup the macro for this?

[HaHoBe]

Hi, ryannjohnsonn,

sorry but I can´t download your attachment. Are there formulas in the range or are these values? How does the data get into that sheet (sorry, but no file).

Ciao,
Holger

[ryannjohnsonn]

I just went through and edited out all the confidential fun stuff... here is a similar

[HaHoBe]

Hi, ryannjohnsonn,

please test the following code which may be called from the procedure writing data (or call it whenever that sheet is activated). You will need to adapt the ranges as I was confused when I saw the workbook having read the description first:

Please Login or Register  to view this content.

Ciao,
Holger

[ryannjohnsonn]

Thanks for the quick reply but that didn't end up doing what I was looking for.

Edit: perhaps I'm "over explaining" it.

Basically, I want it to sum F23:F28, and if that value equals less than 1 I want it to hide rows 20:29. If that value is greater than 1 I want it to unhide rows 20:29.

edit edit: and it only needs to do it once when the workbook is opened.

[HaHoBe]

Hi, ryannjohnsonn,

well, it might have been me as well misunderstanding what you are looking for.

How about

Please Login or Register  to view this content.

This code could either be copied to the Workbook_Open-Event in ThisWorkbook or be called from there.

Ciao,
Holger

[ryannjohnsonn]

That worked great, thanks Holger!