Hiding Blank Rows in a Range
 

Thanks in advance.....you've never let me down yet.

I would like to hide any blank rows in a specific range, but I would
like this to be dynamic as the blank rows (they will contain a
formula) will increase or decrease as the work book is used.

The book is a staff list by site, by area (114 sites in all 727
staff).


Thanks

Matthew