So I got a code that deletes rows based on 2 column conditions. However, it's very slow.
I have about 60, 000 rows and this takes forever.
Sub ClearOldest()
OldestWeek = 34
OldestYear = 2018
i = 2
While Sheet5.Cells(i, "Q") = OldestWeek And Sheet5.Cells(i, "R") = OldestYear...