Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a blank row on spreadsheet
Hi all...my request for advice is a little different
I have a spreadsheet with a large amount of rows of data in it, but the data is separated by a blank row in between different parts of the project. However the blank row is at a random point...Might be after 6 rows of data, then after 3 rows, then after 7 rows, etc. I'd like to delete those blank rows? Any help for the novice here? Thanks in advance Brad Zenner |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a blank row on spreadsheet
If there is a specific column that will have blank cells in just the rows
you want to delete Sub DeleteBlankRows() columns(5).specialCells(xlBlanks).Entirerow.delete End Sub change the 5 (column E) to reflect this column. -- Regards, Tom Ogilvy "Brad Zenner" wrote in message ... Hi all...my request for advice is a little different I have a spreadsheet with a large amount of rows of data in it, but the data is separated by a blank row in between different parts of the project. However the blank row is at a random point...Might be after 6 rows of data, then after 3 rows, then after 7 rows, etc. I'd like to delete those blank rows? Any help for the novice here? Thanks in advance Brad Zenner |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a blank row on spreadsheet
How about a filter?
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete a blank row on spreadsheet
Brad,
Take a look at Edit Go To Special Blanks (do this on a single column) Than do a single Edit Delete Entire Row Record a macro and see how this works. Play with the code and eliminate all the selecting. -- steveB Remove "AYN" from email to respond "Brad Zenner" wrote in message ... Hi all...my request for advice is a little different I have a spreadsheet with a large amount of rows of data in it, but the data is separated by a blank row in between different parts of the project. However the blank row is at a random point...Might be after 6 rows of data, then after 3 rows, then after 7 rows, etc. I'd like to delete those blank rows? Any help for the novice here? Thanks in advance Brad Zenner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do I Delete Blank Pages of a Spreadsheet | New Users to Excel | |||
I cannot delete a blank column from an Excel spreadsheet. | Excel Discussion (Misc queries) | |||
I want to delete multiple blank rows from a spreadsheet | New Users to Excel | |||
how do you delete blank rows in a spreadsheet using an "if" funct | Excel Discussion (Misc queries) | |||
How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) |