delete entire rows

[reza_doang]

hi all,

i need your help.
now i'm doing as data entry, and to simple my work and save my time i need vba code.
how to delete entire rows based on col B.
example, col A have data till A1000 and col B have data till B700, based on B using macro, delete entire rows from B701 till A1000/A last cells.
This is only sample, because data in col A and col B may different.

thanks

[Simon Lloyd]

If you want to delete the entire row from 701 to 100 then[VBA]Rows("701:1000").EntireRow.Delete[/VBA]but we need more from you on why you want to delete the entire rows, based on what criteria, over what range (either the length of A or B).........?