Delete Rows if cell value in a column are blank

[excelrequest]

Greetings!

I am trying to delete all rows of a excel table, if cell value in 'Column F5' onwards is blank.

There are more than 3000 rows of records and data is sorted with blank columns at the end of the table.

For example:

In the attached .jpeg file, column C has blank cells from C9:C, and hence would like to DELETE all the rows from 9 through 3000 rows.

Any advise, would be of great help!

Thank much in advance.

[jaslake]

Hi excelrequest

This code assumes that F4 has a header label. It'll filter the worksheet for all records with blanks in column F, row 5 downward and then delete all those rows. The procedure hasn't been tested.

Please Login or Register  to view this content.

Hope this helps.

John

[excelrequest]

Thank you John. I tried this code.

Unfortunately, I get a Run time error 1004: "Autofilter method of Range class failed."

Could this be due to the pivot table on which I am executing this code? Please advise.

[jaslake]

Hi excelrequest

Have no idea if auto filter works on pivot tables. Others on the forum can probably answer that question. My guess, and it's only a guess, is that you'd need to apply the filter to the data table.

Can't you use pivot table features to filter from the table what you want?

John