How to remove empty rows on the Excel worksheet xlCompare

One of the common tasks: you need to organize data on the worksheet you have: remove empty blocks, sort items, ... xlCompare allows you to automate some of them.
Right click menu on the every worksheet contains Delete Empty Rows command:
Remove empty rows command
It analyzes data on the worksheet and removes empty rows.
If you apply this command you may see that some rows are not deleted. Why? xlCompare tries to find "header" in your table and leave it. If header in your table has empty rows, xlCompare doesn't remove them to preserve formatting. In case if you want to clear header area also, you can remove them manually.

See Also: