Excel 2007 : "Inspect Document" misses hidden rows

I previously was running a macro that resulted in large amounts of blank rows being copied, as seen here. This has since been remedied, though I have about 200 old files that are many times larger than necessary. I planned to use the 'Inspect Document' tool to delete them, though this instead stalls for up to an hours before telling me that there are no hidden rows. Any tips on how to go about finding and deleting these problem rows? Am I misunderstanding how to use the document inspector feature?

Thanks for your help!

Hello beng404,

On your previous post, you received a reply that said "The hidden cells stay hidden and are duplicated 13 times". What the poster meant was "The filtered cells still exist, though they are out of your view, and are duplicated 13 times". While they are literally hidden from your view, "hiding cells" and "filtering cells" are different functions in Excel. So the cells are not visible because they are filtered, not because they are "hidden".

I am completely unfamiliar with the document inspector feature. However, if you're trying to unfilter so that you can see every previously filtered-out cell on your sheet, then remove the filters. To do this, go to "Data" on your ribbon. In the Sort&Filter section, click "Clear". Courtesy http://www.mrexcel.com/forum/showthr...rror-occurring, the code version of this is:

Please Login or Register  to view this content.

As far as finding and deleting excess blank rows, here is code to delete the entire row if the corresponding cell in Column A is blank:

Please Login or Register  to view this content.