CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Threaded View

  1. #1
    Join Date
    Nov 2013
    Posts
    11

    Lightbulb Run time error 13

    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
    Last edited by GremlinSA; November 14th, 2013 at 03:19 AM. Reason: added code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured