Still no luck. Here is the problem in words.

I down loaded to excel a list of purchases from a suppliers website
resulting in a table of six columns and 90 rows. Number of rows
increases over time.Columns are constant headed - Part# -
Description. - Quantity - Unit Price - Total Price - Requisitioner.

The problem is that the excel table Includes rows showing only
supplier information that I want to delete such as rows with only abc:
in one column, the rest of the row blank.

When I run your macro, allrows are deleted.






On Tue, 15 Aug 2006 20:52:34 -0600, "Dave Patrick"
wrote:

You can change "abc" that follows the equal sign to "abc:"