Deleting Rows Between Empty Cells
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.
|