Hello,
I am struggling with a bit of code. The "Object Required" error comes here:
Here is the rest of my code for reference.
Sub Macro1()
Dim LastRow As Integer
Dim AcctNum As Variant
Dim AcctNumMatch As Variant
LastRow = Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To LastRow
AcctNum = Cells(i, 3)
With Sheets("Before Clearing").Range(Cells(i, 3), Cells(LastRow, 3))
AcctNumMatch = .Find(AcctNum, LookIn:=xlValues)
End With
If AcctNumMatch = Empty Then
Cells(i, 11).Value = "No Match"
GoTo Skip1
End If
Cells(i, 11).Value = "Match"
Row1 = AcctNumMatch.Row
Cells(Row1, 11) = "Match"
Skip1:
Next i
End Sub
Thanks for the help!
Steve
Bookmarks