Automatically delete rows where last column has blank data

Hi, I have Excel 2019 and constantly have to download data from a program. The last column has some rows with blanks, and I want to be able to delete those rows without having to filter to blanks, select the rows, and delete them (constantly!).

I have attached an example.

The column where I need to filter to blanks is always named the same thing, and it is always the last column, but the number of columns can vary.

Does anyone have a macro that will do this?

Thank you in advance!

Thank you, how does the Macro Recorder know to filter by that specific column? It's not always the same number of columns in the sheet. I don't write VBA (novice) so I'm not sure what you mean by SpecialCells.

This recorded procedure must be not launched if there is no blank cell within the last column or SpecialCells will crash it
like you can check just running it twice and, as Delete works already only with visible cells, so it is useless here !

Let's see first the filter method so like whatever could be the criteria but first two points :
UsedRange is usefull with a smart designed worksheet.
According to your attachment with the useless comments column that's no more the case
so first insert a blank column between columns J & K in order this comments column moves to column L
so in this case the CurrentRegion can be exploited rather than UsedRange :

Please Login or Register  to view this content.

According to the VBA help let's see now the direct SpecialCells way but not for the visible but for the blank cells.
As this tricky method crashes when nothing matches so before to use it the VBA procedure must first check
if only a blank cell exists via the worksheet function COUNTBLANK :

Please Login or Register  to view this content.

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄