SEARCH AND DELETE MACRO

Giganews Newsgroups
Subject: SEARCH AND DELETE MACRO
Posted by:  JAJOSEPHESQ (jajose…@zoominternet.net)
Date: 3 May 2004

I am looking for a macro to look up the active cell in one workbook in
a spread sheet, then go to another workbook with in the same spread
sheet and look for the contents of the active cell within a named
range.

I don't know if I could then have the maco delete the corresponding
line which containted the match to the find funciton of the active
cell.

Replies