Hey Adam2308,

I tested your workbook and our code but by just testing the J vs BB values there were no matches in your sample.

BTW the .Range code works as well as the .Cells code on my machine - perhaps there was something else going on.

Here's how I tested it:

Sub coupon_loop(): Dim S As String, T As String
Dim lrow As Long, i As Long
Dim fpath As String

Application.ScreenUpdating = False
Application.DisplayStatusBar = True
Application.StatusBar = "Creating CSV Files"

With Worksheets("Coupon")

    lrow = .Range("D" & .Rows.Count).End(xlUp).Row
    For i = 4 To lrow
    
     S = .Cells(i, 10): T = .Cells(i, 54)
    
If .Cells(i, 10) = .Cells(i, 54) And .Cells(i, 11) = .Cells(i, 55) Then GoTo GetNext