J
jamesfc30
Hello,
I have a worksheet with 1061 rows and 7 columns of data.
Example:
column A B C D E
aa bb cc
vv
mm
blank row
ss
I'm need a macro to delete only the blank rows. I've tried the
following macro but it deletes a row when it finds a empty cell. Can
this macro be modified to delete a row with all empty cells only?
Sub DeleteRowsExampleB()
'Delete Selected Rows with specified data
Dim c As Range
Dim x As Range
Set x = Selection
For Each c In x
If c.Value = "" Then
c.EntireRow.Delete
End If
Next c
End Sub
Thank you for your help,
jfcby
I have a worksheet with 1061 rows and 7 columns of data.
Example:
column A B C D E
aa bb cc
vv
mm
blank row
ss
I'm need a macro to delete only the blank rows. I've tried the
following macro but it deletes a row when it finds a empty cell. Can
this macro be modified to delete a row with all empty cells only?
Sub DeleteRowsExampleB()
'Delete Selected Rows with specified data
Dim c As Range
Dim x As Range
Set x = Selection
For Each c In x
If c.Value = "" Then
c.EntireRow.Delete
End If
Next c
End Sub
Thank you for your help,
jfcby