November 12th, 2013, 02:58 AM
Run time error 13
but showing run-time error 13
'The process for Removing duplicates rows in excel files using vb 6.0
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
What is error in this plz help me
Last edited by GremlinSA; November 14th, 2013 at 02:19 AM.
Reason: added code tags
November 12th, 2013, 07:50 AM
Re: Run time error 13
Which line is throwing the error?
Error 13 "Type Mismatch" means that you are mixing two types of variables/data that do not mix
Like for example if you try to put an alpha value into a numeric variable or a non date value into a date variable
Can't tell much from what you posted as the only var that is dimmed is k and that one is not used in that piece of code
Always use [code][/code] tags when posting code.
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!