Code to Interchange Data

[NeedForExcel]

Assume I have First Name in the Active Cell and Last Name in the cell next to the Active Cell.

I want to know how can I write the code that would interchange data between cells.

I know how to do this on Excel, I just want to know how would I write the code for the same.

Help Appreciated!

[Mumps1]

Hi Deep. This seems to work, assuming names are in A1 and B1.

Please Login or Register  to view this content.

[NeedForExcel]

Here the cells will not always be A1 & B1.

I had written the below code. I an unable to understand why it isnt working. If you could please tell??

Please Login or Register  to view this content.

[tigertiger]

Here the cells will not always be A1 & B1.
I had written the below code. I an unable to understand why it isnt working. If you could please tell??

you should add Exit Sub, before label Handler, like this

Please Login or Register  to view this content.

however, we need only one temporary variable, like this

Please Login or Register  to view this content.

[NeedForExcel]

Worked!

Thank You.