![excel vba on sheet deactivate excel vba on sheet deactivate](https://image.slidesharecdn.com/vbastarbasicxref-120830171431-phpapp02/95/vba-starbasicxref-43-728.jpg)
How to remove blank rows in Excel with VBAĮxcel VBA can fix a lot of things, including multiple empty rows. Instead, use one of the more considered approaches discussed below. The bottom line: if you don't want to mess up your data, never delete empty rows by selecting blank cells. And in the resulting table, all incomplete rows ae gone, even row 10 where only the date in column D was missing: The below image shows the original table on the left and the resulting table on the right. What's wrong about this technique? It selects all blanks in a range, and consequently you will end up deleting all rows that contain as much as a single blank cell. There are a few different ways to delete empty lines in Excel, but surprisingly many online resources stick with the most dangerous one, namely Find & Select > Go To Special > Blanks. Fastest way to delete blank lines in Excel.
![excel vba on sheet deactivate excel vba on sheet deactivate](https://i.ytimg.com/vi/FJMITrytWQA/maxresdefault.jpg)
How to remove rows if a certain column is blank.
![excel vba on sheet deactivate excel vba on sheet deactivate](https://1.bp.blogspot.com/-xttRBxHfoyw/V6txZhMmK8I/AAAAAAAAGiI/PKroHe1AdK81M2ATbSKW7qZnbAOoNGVbQCLcB/s1600/excel_context_menu.jpg)