delete the row when meet the cell is null

[hktom]

Dear all,

we have thousands row of data, we need vba to help

steps
1. we start from A2
2. when we meet the column A cell is null, then we count at most 3 row under the null value, remain at most 3 row.
if more then delete. attached pls find the sheet1 is questions which is have yellow color , that is we need to delete
3. the answer is in sheet 2 name answer

pls help
tks
tom

[ikboy]

See if help

Please Login or Register  to view this content.

[hktom]

thank ikboy. it great and perfert. it solved