Here's a good one. Why does the workbook (see attachment) filter off blank rows leaving the worksheet skinny?
I should also mention, I used a macro to add the autofilter. The code used to do this is:The attachment contains no macro's, apply a filter and notice how the worksheet becomes skinny...Range(Cells(1, 1), Cells(65536, 27)).Select Selection.AutoFilter
Bookmarks