I have a named range which includes some rows which are empty. When I apply
subtotals using a macro, all the empty rows end up in the bottom category.
What code can I include in the macro to hide all the empty rows.