+ Reply to Thread
Results 1 to 2 of 2

Paste Special throwing error first time

  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)

    Please Login or Register  to view this content.
    Last edited by DonkeyOte; 11-30-2010 at 02:13 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Paste Special throwing error first time

    @sid_misra, please remember to use CODE tags around your VBA at all times (per Forum Rules).

    Given first post etc I've modified for you ... for more info on tags etc see: here

+ Reply to Thread

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