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:
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