I am receiving an object required error on the following line
I would like to select the row that is associated with cell A2 and then delete it below is the entire sub
Code:
Sheets(AA).Range("A2").Row.Delete
I would like to select the row that is associated with cell A2 and then delete it below is the entire sub
Code:
Sub Duplicate_LD_1WEEKUPDATE()
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
'X Removes potential duplicate entries into the collection of COT values X
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Dim AA As String
AA = ActiveSheet.Name
If Sheets(AA).Range("C2") = Sheets(AA).Range("C3") Then
Sheets(AA).Range("A2").Row.Delete
Sheets("M_" & AA).Range("A5").Row.Delete
End If
End Sub
Last edited: