Without all them? That just about removes all options, except maybe Filter.

Go into DataFilter<Advanced Filter and look at your options there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TUNGANA KURMA RAJU" wrote in
message ...
comparing a worksheet1 range(A:A) values with othersheet range(A:A)
values,and if value not found in othersheet,delete all row values from the
sheet1, without creating a separate sheet.vba code or function?