I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.

This macro should do what you want...

Sub DeleteBlankRows()
Rows.SpecialCells(xlCellTypeBlanks).Delete
End Sub

If you are not sure how to implement this, right click the worksheet tab you
want to use this on, select View Code from the popup menu that appears,
copy/paste the above into the code window that appears, click anywhere
inside the code you just pasted and press F5 to run it. All blank rows up to
and including those in the data itself should now be gone.

--
Rick (MVP - Excel)


"Daren" wrote in message
...
I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.

Thanks!

"Rick Rothstein" wrote:

This macro should do what you want...

Sub DeleteBlankRows()
Rows.SpecialCells(xlCellTypeBlanks).Delete
End Sub

If you are not sure how to implement this, right click the worksheet tab you
want to use this on, select View Code from the popup menu that appears,
copy/paste the above into the code window that appears, click anywhere
inside the code you just pasted and press F5 to run it. All blank rows up to
and including those in the data itself should now be gone.

--
Rick (MVP - Excel)


"Daren" wrote in message
...
I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.

Best to sort the data to put all the blank rows at the top of the bottom,
then delete them. Alternatively, go to Access and use a query to delete the
blank rows before you copy the data.


"Daren" wrote:

I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.

Thanks.

"Duke Carey" wrote:

Best to sort the data to put all the blank rows at the top of the bottom,
then delete them. Alternatively, go to Access and use a query to delete the
blank rows before you copy the data.


"Daren" wrote:

I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.

F5SpecialBlanksOK

EditDeleteEntire Rows


Gord Dibben MS Excel MVP

On Thu, 4 Sep 2008 11:55:01 -0700, Daren
wrote:

I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.

Thanks!

"Gord Dibben" wrote:

F5SpecialBlanksOK

EditDeleteEntire Rows


Gord Dibben MS Excel MVP

On Thu, 4 Sep 2008 11:55:01 -0700, Daren
wrote:

I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.