Deleting row if empty cell without using a loop

[MrIdontknowexcel]

Hi, I wanted to know if theres a way to allow excel go through a range of cells (A20-A2000) and will delete the row if the cell is empty. I want to know if this can be done without using a loop, because when i use a loop it takes to long for it to go through all the cells and delete the rows. Can someone please help.

[oeldere]

Maybe you can try this one, on a dummy of your workbook.

Please Login or Register  to view this content.

[Marcol]

No need for VBa

Filter Column A for blanks, delete the resulting rows, remove the filter.

[MrIdontknowexcel]

Thanks oeldere, that did work but how do i have if so i goes through range A:20 - A:2000 only because I only want certian rows being affected.

[oeldere]

Try this one, on a dummy of your workbook

Please Login or Register  to view this content.

[MrIdontknowexcel]

Yup, that worked perfectly. You are the man! +rep.

[oeldere]

Glad i could help.

Notice, you also get an good non-VBA-solution in #3 from Marcol.

If you problem is solved, will you also mark the question as solved.