+ Reply to Thread
Results 1 to 4 of 4

Selection copy past to another sheet and run another sheet macro

  1. #1
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Selection copy past to another sheet and run another sheet macro

    Hi friends,

    I am tring to COPY and PASTE into another workbook and run another workbook code. but getting problems to copy and past the selection range.

    Simple If I select A1, A1 copy and past it to another sheet Range("Y2")
    Same If I select D32, D32 copy and past it to another sheet Range("Y2")

    Please advice me.

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Selection copy past to another sheet and run another sheet macro

    What is the problem?
    Last edited by davesexcel; 12-16-2017 at 05:25 AM.

  3. #3
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Selection copy past to another sheet and run another sheet macro

    hi davesexcel,
    Past problem.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Selection copy past to another sheet and run another sheet macro

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.


    To add a file to a post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] macro to copy data range from sheet and past to specific other sheets
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-31-2017, 05:31 AM
  2. [SOLVED] Macro for copy and past in the last populated cell, according to the attached sheet
    By ricdam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-01-2015, 09:19 PM
  3. macro to copy certain cells and past to another sheet.
    By alwinaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2013, 08:48 AM
  4. Macro to copy 6 tabs to new sheet and past as values.
    By MelPilgrim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2012, 05:55 PM
  5. [SOLVED] Seach for data from one sheet to another sheet and copy past adjacent columns
    By mahtabshaikh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2012, 10:19 AM
  6. Creating Macro to copy excel sheet from workbook1 and past into excel sheet workbook2
    By t_gagliardi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2012, 01:19 PM
  7. Replies: 3
    Last Post: 11-12-2010, 04:31 AM

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