Delete rows based on match criteria in two excel files or single Excel File

[DocAElstein]

This code has limitation of LR1=5000 & LR2= 5000(plz remove the limitations of this macro)

Avinash,
Your apparent ability or unwillingness to understand or remember anything is now at such a high level that
Either
_1) You are trying deliberately as hard as possible to annoy us
or
_2) If _1) is not correct, then you really should now see a Doctor or Psychologist, since you are very likely seriously mentally Ill

We have had the making last row dynamic issue over and over again. Even just recently almost an identical question from you was answered, and the macro was also almost identical!!!:
https://eileenslounge.com/viewtopic.php?f=30&t=34937
https://eileenslounge.com/viewtopic....271316#p271316
https://excelfox.com/forum/showthrea...ll=1#post14565


Edit: And you posted this same question a few days before.. Bro you are in a total mixed up mess!!!
(https://excelfox.com/forum/showthrea...ll=1#post14599 )

---

one more issue is there with this macro
I am sending the sample file plz run the macro & see the output
If error.xlsx is blank sheet then it is giving something different output plz see

I have no idea what you are asking. I have no idea what it is that you are trying to say .
Possibly it is something to do with problem 2 here:
https://excelfox.com/forum/showthrea...ll=1#post14565
The problem is your usual incompetence. You mix everything up, and half the time either don’t know what you want or cannot explain what you want. This is not a VBA issue. This is a problem with your brain that needs medical help.

Alan


Edit.. and here we go yet once again .... same question
https://eileenslounge.com/viewtopic....272085#p272085
_.. same wrong answer...
https://eileenslounge.com/viewtopic....272094#p272094
( wrong caslculation of Lr2 )
_... and yet agin you think its right ... and another set of duplicated cross postings will begin when you realise yet agin that it is wrong... Bro - you need medical help, fast! NO JOKE!