problem delecting rows based on a condition in another workbook

hey all

i'm using two workbooks "database.xls" and "ref to delete.xls"

"ref to delete.xls" contains reference numbers to delete in "database.xls",
when macro finds a that a ref number from "ref to delete.xls" in "database.xls", the entire row in "database.xls" that contains a ref. number in "ref to delete.xls" should be deleted.

notice: ref. no column is "A", in both workbooks


thanks in advance
regards

http://www.vbaexpress.com/forum/show...391#post179391

http://www.mrexcel.com/forum/showthr...71#post1873171