John

DataFilterAutofilter.

Select the column that would have the cell with the content and filter for
that value.

Then F5SpecialVisible cells and OK.

EditDelete row.


Gord Dibben Excel MVP



On Mon, 13 Jun 2005 14:16:02 -0700, John Chan <John
wrote:

I would like to delete a whole row based on the contents of a cell that
resides in the same row to be deleted. This would then apply to the whole
spreadsheet, row by row.