Auto Deletion of 4 consecutive rows out of every 5
 

I have a spreadsheet in which 4 of every 5 Rows need to be deleted. ie: Row
1 is good, Row 6 is good, Row 11 is good, Row 16 is good, etc. I need to
delete Rows 2-5, 7-10, 12-15, etc. I would prefer to set a variable in the
macro to tell it how many sets of 4 consecutive rows I need deleted (with one
good row between each bad set of 4). The rows that need to be deleted are not
entirely blank, some of the cells have data (not needed) but there are a few
rows that are entirely blank. It needs to delete the rows irreguardless of
any data in that row. Help is appreciated as I am not a programmer but you
guys are really good.

OR

Every 5th cell in column A has data. I need to delete all ROWS that have no
data in COLUMN A(even if it is a "space" that was used to delete previous
data) in column A. How would it know when it reached the end of the data and
continue to delete the balance of the blank spreadsheet?

Thanks
Danny

Auto Deletion of 4 consecutive rows out of every 5
 

If you change
a = 1
to
a = 2

it will leave the rows he described.

--
Regards,
Tom Ogilvy

"filo666" wrote in message
...
Sub DeletingAllButFifth()
Dim a As Double
Dim b As Integer
a = 1
While a < 1000
b = 1
While b < 5
Rows(a).Delete
b = b + 1
Wend
a = a + 1
Wend
End Sub

'remember that in: "While a < 1000" the 1000 number means the total rows
in
your
'sheet change it to a number you want

HTH

"scratching my head" wrote:

I have a spreadsheet in which 4 of every 5 Rows need to be deleted. ie:
Row
1 is good, Row 6 is good, Row 11 is good, Row 16 is good, etc. I need to
delete Rows 2-5, 7-10, 12-15, etc. I would prefer to set a variable in
the
macro to tell it how many sets of 4 consecutive rows I need deleted
(with one
good row between each bad set of 4). The rows that need to be deleted
are not
entirely blank, some of the cells have data (not needed) but there are a
few
rows that are entirely blank. It needs to delete the rows irreguardless
of
any data in that row. Help is appreciated as I am not a programmer but
you
guys are really good.

OR

Every 5th cell in column A has data. I need to delete all ROWS that have
no
data in COLUMN A(even if it is a "space" that was used to delete
previous
data) in column A. How would it know when it reached the end of the data
and
continue to delete the balance of the blank spreadsheet?

Thanks
Danny