Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA code needed for auto deletion upon opening | Excel Discussion (Misc queries) | |||
Auto deletion of excel file after a certain date - expiry | Excel Discussion (Misc queries) | |||
How can I activate a macro of auto deletion with respect to date | New Users to Excel | |||
Row deletion and auto filter | Excel Discussion (Misc queries) | |||
Protecting a spreadsheet from deletion | Excel Discussion (Misc queries) |