Hey guys, thanks for the very quick responses.

They are both good solutions but the issue I'm struggling with is that the rows I need to analyse and hide are not in a continuous range.

I.e. on one sheet, it is only rows 2, 3, 7, 9, 85, 89, 112-115, 189, 193-197, 200, 204, 205 that I need to look at and hide, if their F column value is 0. No matter what the value of row 1, 4, 5, 6, 8, 10-84, etc., even if it is 0, I don't want to hide it (or even look at it for that matter).

On another sheet, it is a different set of rows to analyse/hide.

Other than an if statement for each row, do you have any suggestions for an efficient way to loop through this disparate set of rows?

As for the dialog popping up a lot, it is expected that the rows will have a zero value so it *shouldn't* pop up often. (If it does, I expect the user to choose to cancel the process and resolve the underlying issue).

Thanks again