Norman,
Here's an example of what I'd like to happen. If it's going to be hugely
complex, then I can live without it!

If (A15="xxxx",hide the next 4 rows,don't hide the next 4 rows)

thanks,
--
Jock Waddington


"Norman Jones" wrote:

Hi Jock,

It would be necessary to use VBA.

If this is acceptable, post back with details of the range and the hide
condition.

---
Regards,
Norman



"Jock W" wrote in message
...
Using an 'If' function, is it possible to hide a row when criteria aren't
met?
--
Jock Waddington