http://www.excelfox.com/forum/f20/delete-list-contain-matching-second-list-589/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From:Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 04 October 2012 9:58
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ macro: d
Hi,
Use this Code, Just Create Two Name Ranges,
Sheet1!B2="rngRange"
Sheet2!B2 =" MapDelete"
Sub ExcludeFromList()
Dim objDicMap As Object
Dim VarArrData
Dim VarArrResult
Dim rngCell As Range
Dim lngCOunt As Long
VarArrData = Intersect
Sub sample_code()
Application.ScreenUpdating = False
Dim a As Range
Dim SrchRnga As Range
Dim i As Long
Set SrchRnga = Sheets(1).Range("b1: b" &
Sheets(1).Range("b65356").End(xlUp).Row)
For i = 3 To Sheets("table").Range("b65356").End(xlUp).Row
Do
Set a = SrchRnga.Find(Sheets("table").Range("b"
