Thanks for the feedback.

It is the easiest method IMO if you have a column with blank rows representative
of all.


Gord

On Wed, 11 Jul 2007 00:30:11 -0500, "Just Me" wrote:

Thanks Gord !! that was by far the easiest way to do what I was wanting to
do...


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Select a column and F5SpecialBlanksOK

EditDelteEntire Row


Gord Dibben MS Excel MVP

On Tue, 10 Jul 2007 11:59:13 -0500, "Just Me" wrote:

When I copy and paste data from my online credit card statement it has a
colored row that seperates each entry. is there any way besides doing it
manually to delete every other row?