Swap Contents of Two Cells in Excel

This post will guide you how to swap contents of two cells in Excel. How do I swap cell contents with VBA Macro code in Excel. how to swap values between two cells in Excel.

Swap Contents of Two Cells


You can use a VBA Macro code to quickly swap contents of two selected cells in Excel. Just do the following steps:

#1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

Get the position of the nth using excel vba1

#2 then the “Visual Basic Editor” window will appear.

#3 click “Insert” ->”Module” to create a new module.

convert column number to letter3

#4 paste the below VBA code into the code window. Then clicking “Save” button.

Sub SwapContent()
    Set Cell1 = Application.Selection
    Set Cell1 = Application.InputBox("select the first Cell:", "SwapContent", Cell1.Address, Type:=8)
    Set Cell2 = Application.InputBox("select the second Cell:", "SwapContent", Type:=8)
    tmp1 = Cell1.Value
    tmp2 = Cell2.Value
    Cell1.Value = tmp2
    Cell2.Value = tmp1
End Sub

swap contentof two cells5

#5 back to the current worksheet, then run the above excel macro. Click Run button.

swap contentof two cells1

#6 select the first cell, such as: B1

swap contentof two cells2

#7 select the second cell, such as: C1

swap contentof two cells3

#8 Lets see the result.

swap contentof two cells4

 

Related Posts

Find and Replace Multiple Values

This post will guide you how to find and replace multiple values at once with VBA macro or using formula  in Excel. How do I make multiple find and replace in Excel. Suppose that you have a few cells containing ...

VBA Macro For VLOOKUP From Another Sheet

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

How To Insert Comments in Protected Worksheet in Excel

This post will show you how to allow comments in a protected worksheet in Excel. You can easily to insert comments into cells in a normal worksheet in Excel, but if want to insert a comment in a worksheet that ...

How To Convert Text to Upper Cases(Using VBA) in Excel

This post will show you how to switch from lower case to upper case in Excel. and I am going to show you two different ways of converting text to upper cases using formula or VBA macro in Excel 2013,Excel ...

How To Hide Every Other Row in Excel (Using VBA)

This post will show you how to hide alternate rows or columns in Excel or how to hide every third, fourth, fifth row or column in Excel. If you want to hide every other row in your current worksheet, how ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar