Results 1 to 2 of 2

Paste Special throwing error first time

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Paste Special throwing error first time

    I have the following snippet where I am trying to copy a range from a different sheet to a new sheet.The first time when i run this sub,it throws out the 1004 error stating that paste special method failed.But the next time i run the same using a button it works.Any solutionto this is appreciated.(The commented ones are the things i tried)

    Application.CutCopyMode = True
        Range("T37:V1000").Select
        Selection.Copy
        
        
        Sheets("Summary").Select
        Worksheets("Summary").Activate
          ActiveSheet.Unprotect
       
       
       'Worksheets("Summary").Range("C40").Select
       'Worksheets("Summary").Activate
       'Worksheets("Summary").Activate
      
    'Range("C40").Select
    
    'On Error Resume Next
    
     'On Error GoTo ErrHandler:
     Range("C40").PasteSpecial  ' cause an error
    Last edited by DonkeyOte; 11-30-2010 at 02:13 PM.

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