problem deleting rows based on a condition in another workbook

[mehdoush]

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

 

[xld]

Cross-posted at VBAExpress http://www.vbaexpress.com/forum/showthread.php?t=25705