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

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