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?

With ACtivesheet
iLastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For i = iLastRow to 1 Step -2
.Rows(i).delete
Next i
End With

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Just Me" wrote in message
...
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?

select a column
datafiltersautofilter
in the aut0ofilter header select blanks
select all the visible rows and edit delete row

or select all and data sort
the empty rows will move to the bottom

"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?

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?

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?

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?