Thanks to help from Nigel yesterday, I now have a macro which detects empty
cells in C2-C10 and hides those rows leaving other rows alone.



I should like to toggle that so is there a code for "are any rows hidden"
without going from row to row throughout the database?



If Rows.hidden = true then

Rows.unhide

Else

HideEmptyRows 'the macro to hide empty rows

Endif



Any suggestions - thanks



Camlad