but showing run-time error 13
'The process for Removing duplicates rows in excel files using vb 6.0
Code:Mrg_Row = wsN.UsedRange.Rows.Count Mrg_Col = wsN.UsedRange.Columns.Count Dim k As Long For i = 2 To Mrg_Row Form2.Caption = "Removing duplicates pleas wiat..." & i If wsN.Range(wsN.Cells(1, 1), wsN.Cells(1, Mrg_Col)).Value = wsN.Range(wsN.Cells(i, 1), wsN.Cells(i, Mrg_Col)).Value Then wsN.Range(wsN.Cells(i, 1), wsN.Cells(i, Mrg_Col)).Delete End If Next
What is error in this plz help me