It's been a while since I've done anything with excel, Can anyone help me
remove blank rows from a column that has lots of data with every other row
being blank. I'm not an expert so please explain in layman's terms. Thank
you,

Rod

sort the sheet on that column, the blank cells will be together. select the rows
and delete them.

--


Gary


"Digital2k" wrote in message
...
It's been a while since I've done anything with excel, Can anyone help me
remove blank rows from a column that has lots of data with every other row
being blank. I'm not an expert so please explain in layman's terms. Thank you,

Rod

Make a copy and test this
Sub DeleteEmptyRow()

On Error Resume Next
Columns("D:D").Select 'Change to column that has blank cells
Selection.SpecialCells(xlCellTypeBlanks).EntireRow .Delete
ActiveSheet.UsedRange
Range("A1").Select
Rows("1:1").Select
Range("B1").Activate
End Sub

"Digital2k" wrote:

It's been a while since I've done anything with excel, Can anyone help me
remove blank rows from a column that has lots of data with every other row
being blank. I'm not an expert so please explain in layman's terms. Thank
you,

Rod

I have an alternative which doesn't involve sorting your data, or
writing a program to do it (even though this is a programming
group)...

Select the row with the blanks in it.
Press F5, then special..
Select 'Blanks' and press ok

This will select every cell which is blank...

Then right click on the of the cells it has selected, press
'Delete...' and select 'Entire Row'

This will delete all the rows you have selected.

Tony


On May 2, 12:59 pm, "Digital2k" wrote:
It's been a while since I've done anything with excel, Can anyone help me
remove blank rows from a column that has lots of data with every other row
being blank. I'm not an expert so please explain in layman's terms. Thank
you,

Rod