Problem 1)
R u talking about this Doc SirCode: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 = Ws1.Range("A" & Ws1.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 have used this macro
Do u mean to say that
I have to use this in this macro
Problem 2Code:Let Lr1 = Ws1.Range("A" & Ws1.Rows.Count & "").End(xlUp).Row Let Lr2 = Ws2.Range("A" & Ws2.Rows.Count & "").End(xlUp).Row
https://eileenslounge.com/viewtopic.php?f=30&t=34937
U r talking about this
so may i know what changes is required in the second problem so that i can put the same & be safe
3)Thnx Bro for all of ur Great Efforts, this is Best thing about u
Thnx for knowing me about the problems
& Yes this question i asked u in last year , & it is working fine
I just want to make the system Awesome Like u Bro
U r the one of the best person i ever met
Thnx for keeping a eye into all of my problems that i may have infuture




Reply With Quote

Bookmarks