Code:Sub STEP3() Dim Wb1 As Workbook, Wb2 As Workbook Set Wb1 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\1.xls") Set Wb2 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\Hot Stocks\H2.xlsb") Dim Ws1 As Worksheet, Ws2 As Worksheet Set Ws1 = Wb1.Worksheets.Item(1) Set Ws2 = Wb2.Worksheets.Item(2) Dim Lr1 As Long, Lr2 As Long: Let Lr1 = Ws1.Range("A" & Ws1.Rows.Count & "").End(xlUp).Row Let Lr2 = Ws2.Range("A" & Ws2.Rows.Count & "").End(xlUp).Row Dim rngSrch As Range: Set rngSrch = Ws2.Range("A2:A" & Lr2 & "") Dim rngDta As Range: Set rngDta = Ws1.Range("B2:B" & Lr1 & "") Dim Cnt As Long For Cnt = Lr2 To 1 Step -1 Dim MtchedCel As Variant Set MtchedCel = rngSrch.Find(what:=rngDta.Item(Cnt), After:=rngSrch.Item(1), LookIn:=xlValues, LookAt:=xlWhole, SearchDirection:=xlNext, MatchCase:=True) If Not MtchedCel Is Nothing Then Else rngDta.Rows(Cnt).EntireRow.Delete Shift:=xlUp End If Next Cnt Wb1.Close SaveChanges:=True Wb2.Close SaveChanges:=True End Sub
I updated the macro Sir & i will use this macro
& Now problem is solved Doc Sir
any more updates & suggestions are there then plz let me know Doc Sir
& Thnx For ur Great Suggestion & for helping me in solving this problem Sir




Reply With Quote

Bookmarks