Results 1 to 8 of 8

paste method of worksheet class failed

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-10-2012
    Location
    Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    129

    paste method of worksheet class failed

    Hi my code is as follows
    step 1
    sheet pool activate
    filtering certain records
    selection
    copy
    another sheet activate
    filtering same data
    paste

    but error is shown while pasting

    please resolve
    Sub cccc()
    Worksheets("Pool").Activate
       Selection.AutoFilter Field:=1, Criteria1:="=*Adilabad Nizmabad Kamaredey Pool*", Operator:=xlAnd
    Range("a6").Select
    ActiveCell.EntireColumn.Select
    Cells.Find(What:="Adilabad Nizmabad Kamaredey Pool").Activate
        ActiveCell.Offset(0, 1).Range("A1").Select
        Range(Selection, Selection.End(xlDown)).Select
        Range(Selection, Selection.End(xlToRight)).Select
    Selection.Copy
    Worksheets("hq").Activate
       Selection.AutoFilter Field:=1, Criteria1:="=*Adilabad Nizmabad Kamaredey Pool*", Operator:=xlAnd
    Range("a6").Select
    ActiveCell.EntireColumn.Select
    Cells.Find(What:="Adilabad Nizmabad Kamaredey Pool").Activate
        ActiveCell.Offset(0, 1).Range("A1").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.PasteSpecial
    ActiveSheet.Range("A1").Select
    Application.CutCopyMode = False
    End Sub
    Last edited by arlu1201; 07-10-2012 at 06:33 AM. Reason: Use code tags in future

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