Breaking News: Grepper is joining You.com. Read the official announcement!

Swap cell contents in Excel

Careful Capybara answered on December 14, 2023 Popularity 8/10 Helpfulness 1/10

answer Swap cell contents in Excel

Swap cell contents in Excel

Comment

You can assign this VBA macro to a button or hotkey. Select any two cells and run the macro below to swap the two cell's contents.

Sub Swap()     
    If Selection.Count <> 2 Then     
         MsgBox "Select 2 cells (only) to swap."     
         Exit Sub     
    End If     
    Set trange = Selection     
    If trange.Areas.Count = 2 Then     
         temp = trange.Areas(2)     
         trange.Areas(2) = trange.Areas(1)     
         trange.Areas(1) = temp     
    Else     
         temp = trange(1)     
         trange(1) = trange(2)     
         trange(2) = temp     
    End If     
End Sub

Popularity 8/10 Helpfulness 1/10 Language javascript

Source: superuser.com

Tags: c++ cell excel swap

Link to this answer
Share Copy Link

Contributed on Dec 14 2023

Careful Capybara

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Swap cell contents in Excel

Contents

More Related Answers

Swap cell contents in Excel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.