+ Reply to Thread
Results 1 to 3 of 3

Swap Selected Ranges on different worksheets

  1. #1
    Registered User
    Join Date
    11-21-2019
    Location
    Salem, OR
    MS-Off Ver
    Excel for Office 365
    Posts
    16

    Swap Selected Ranges on different worksheets

    Hello all,

    I have this code below that I inherited from the previous owner of the workbook I am using. Swapping ranges on the same worksheet work fine, but I am now needing to work on multiple sheets and find myself needing to swap values on selected ranges between sheets. I have made a few attempts writing my own mods and trying to use the macro recorder as well, but cannot get it to work just right. Hoping someone in this forum can provide a solution or some code to get me on the right track.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Swap Selected Ranges on different worksheets

    It changes the method of using the function slightly:

    Please Login or Register  to view this content.
    Select the first range then run the macro. Now select the second range on the same sheet or a different sheet. The range values will be swapped.

    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Registered User
    Join Date
    11-21-2019
    Location
    Salem, OR
    MS-Off Ver
    Excel for Office 365
    Posts
    16

    Re: Swap Selected Ranges on different worksheets

    WideBoyDixon,

    Thank you very much for your help! Worked like a charm. Hahaha! I thought I was so clever using sheet activations.

    Cheers!

+ 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 swap selected cell contents
    By elgato74 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2017, 12:43 AM
  2. How to Swap Variable Ranges?
    By mumair in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-20-2017, 05:49 PM
  3. Swap 2 Selected Names
    By MarvinP in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-19-2016, 03:47 PM
  4. Swap ranges within the same row
    By JWil408 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2015, 09:24 AM
  5. [SOLVED] Swap Selected Visible Cells to Values to right of the Selection
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2014, 02:46 PM
  6. Swap Two Cell Ranges?
    By papagorgio in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2010, 01:46 PM
  7. [SOLVED] Macro to name ranges for selected worksheets
    By carl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2006, 12:15 PM

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