This is crazy!! I have told you so many times!!!
Lr1 is for Ws1
Lr2 is for Ws2
Lr1 = Ws1.Range("B" & Ws1.Rows.Count).End(xlUp).Row
Lr2 = Ws2.Range("B" & Ws2.Rows.Count).End(xlUp).Row
If a macro like those originated from me, which it may well have, then the basic idea , originally, would have been this:
A row is possibly being deleted in a fairly bog standard conventional worksheet code line in a Loop. Hence it must Loop backwards… Based on the initial given requirement, the macro was doing this: A column of data in a worksheet is gone through/looped. That column would be the rngDta. We can see that in the Loop since at each Loop as the Loop count variable, Cnt , changes, we have the next back/down Item in the rngDta as What:= is being looked for rngDta.Item(Cnt)
In these macros , it seems that the data is in Ws1 , and the rngDta from a dynamic last row, is given by something of the form
Ws1.Range("B" & Ws1.Rows.Count).End(xlUp).Row
That is the data that is gone through/Looped , so the Looping should be done like
__For Lr1 To 1 Step -1
The range in which each data item is looked for is rngSrch , which would appear in this macro to be in Ws2 and correspondingly , originally we would have dynamically obtained that range something like
Ws2.Range("C1:C" & Lr2 & "")
With our dynamically obtained last row being obtained something like this
Ws2.Range("B" & Ws2.Rows.Count).End(xlUp).Row
Based on if a match is or is not found, then something is or isn’t done.
It is starting to give the impression that you have no access to, or knowledge what so ever of Excel. let alone VBA.
You often don't / won't understand something that a small mentally handicapped child could and mostly would understand.
It is clear that there is no real inteligence behind who or what is producing the questions: most of the time you have no idea at all about the questions you are pasting.
You seem to be pasting badly explained mixed up questions , and as before, posting some canned replies that you don’t seem to understand either yourself half the time.
Whatever it is you are attempting to do , it is incredibly inefficient, and mostly achieves nothing other than just wasting every bodies time.
The only amazing thing is that you are getting worse and worse. Whatever you are attempting was, up until now, wasting 10 – 100 times more time than necessary. Your post are now becoming so full of errors and so mixed up that you are wasting 1000 times more than necessary.
It is totally crazy, and getting crazier by the day… .
But some people at excelforum seem happy to play the game with you. So maybe best is to just register another dozen accounts there and continue in your games.
I am beginning to think that your main aim is to just keep as many people possible busy at a forum answering the same and similar questions over and over again… I think there is at least a small chance that you are a Bot are part of an attempt to develop a Bot to ask questions at forums..
It is clear that there is no real inteligence behind who or what is producing the questions: most of the time you have no idea at all yourself about the questions you are pasting, that is to say duplicate cross posting with multiple accounts everywhere...( https://excelfox.com/forum/showthrea...h-Introduction )
Reply With Quote
Bookmarks