Results 1 to 5 of 5

Copy Paste between sheets

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2008
    Location
    UK
    Posts
    63

    Copy Paste between sheets

    Hi,

    I want to copy a range from Sheet2 to Sheet1.

    This works fine with code below:

    '
     Keyboard Shortcut: Ctrl+j
    '
        Sheets("Sheet2").Select
        Range("A7:D37").Select
        Selection.Copy
        Sheets("Sheet1").Select
        Application.Run "BLPLinkReset"
        Range("A12").Select
        ActiveSheet.Paste
    End Sub
    Problem happens when I put this code into a Command Button and I get following message:

    Run-time error
    Select method of Range class failed

    Any idea why?
    How can I do copy paste function using Command Button?

    Thanks,
    Nix
    Last edited by nicolaforni; 07-20-2011 at 03:58 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