This is a very useful tool, but I have deleted rows I didn't mean to before.
Always chaeck to make sure that just cause one cell is blank, tyhat you want
to delete anything else in that row.

"Kieran" wrote:


KatyLady,

Use the autofilter function (Data, filter, autofilter) after putting
youa active cell somewhere in you list.
You should see some 'little arrows' appear int eh column headings.
Click on the arrow in the column of interest, scroll down the list then
displayed and choose {blanks}.

That sould then show you only those rows wher ethe column is blank.
Sleect the entire rows using the 1,2,3,4,... grid reference on the left
of the sheet, right click on the grid left heading, and select delete.

Then click on the arrow in the column of interest, scroll down the list
then displayed and choose {all}.

That should have deleted the rows...


--
Kieran

Born ignorant and still perfecting the art
------------------------------------------------------------------------
Kieran's Profile: http://www.excelforum.com/member.php...fo&userid=1247
View this thread: http://www.excelforum.com/showthread...hreadid=374987