Easy question!! Macro code

[ericam]

I have many columns of numbers in Excel. In column A some cells are empty. If the cell is empty i want the whole row to be deleted. For instance:
1 2 3 4 5 6 7 8 9 10
9 8 7 6 5 4 3 2 1
1 2 3 4 5 6 7 8 9 10

should look like this:

1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10

Thank you!!!!!!

 

[Norie]

As far as I can see from your example column A isn't empty.

Why not just use Data>Autofilter/Advanced Filter...?

 

[ericam]

Sorry its just the way it posted without leaving out the first number but column A is the one that is supposed to be empty. How exactly can i use Auto filter please?