Results 1 to 2 of 2

showing error at Selection.Delete Shift:=xlToLeft

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-06-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    193

    showing error at Selection.Delete Shift:=xlToLeft

    Sub original1()
    Dim k As Integer
    Dim i As Integer
    For k = 3 To 20
    If Range("Q" & k).Value <> "" Then
    
    MsgBox ActiveCell.Row
    
    ActiveCell.Offset(1, 0).EntireRow.Insert
    With ActiveCell
    For i = 1 To 10
        .Resize(1, 4).Copy Destination:=Worksheets("Master File").Range("M" & .Row + 1)
        .Resize(1, 4).Select
        '.Resize(1, 4).Value = ""
        'ActiveCell.Value = ""
        '.Resize(1, 4).Delete Shift:=xlToLeft
        Selection.Copy
        Selection.Delete shift:=xlToLeft
        If .Value = "" Then
        End If
    Next i
    i = i + 1
    End With
    Else
    Exit Sub
    End If
    Next k
    k = k + 1

    error shows object required
    any one help?
    Last edited by anilg0001; 06-15-2013 at 07:55 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1