Hi to all of you, kindly require to provide me VBA so that to delete entire row if the value in col. "J" is "0", zero . Therefore that the rows arises to 700000+ and the code due to other commands should not start with "Dim as Long.... e.t.c." Thank you all in advance