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
|