Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help to clear data & delete rows
help me out...
the line below clears all contents in the sheet basebook.Worksheets("SUNDRY CREDITORS").Cells.Clear but I want ... (1) to clear only data below row6 and (2) to clear only data below row6 and after column ac Secondly - to delete I need to check value in column h of each row, starting from row6; if value is blank or zero or error, that row should be deleted, then the check must be applied to next row, check then ignore or delete, so on till end of the sheet. thanks in advance.. Eddy stan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help to clear data & delete rows
any help on this...
"Eddy Stan" wrote: help me out... the line below clears all contents in the sheet basebook.Worksheets("SUNDRY CREDITORS").Cells.Clear but I want ... (1) to clear only data below row6 and (2) to clear only data below row6 and after column ac Secondly - to delete I need to check value in column h of each row, starting from row6; if value is blank or zero or error, that row should be deleted, then the check must be applied to next row, check then ignore or delete, so on till end of the sheet. thanks in advance.. Eddy stan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear and Copy vs Delete | Excel Discussion (Misc queries) | |||
Delete rows with no data | Setting up and Configuration of Excel | |||
question data validation and delete/clear behavior | Excel Programming | |||
Clear/Delete an Array | Excel Programming | |||
Delete certain rows of data... | Excel Programming |