Is it possible to swap numbers between cells?

[Johncobb]

I have a worksheet, A1:CB200.
In my worksheet I would like to swap numbers between cells, is it possible to do it automatically? Can Excel do it in one click?
For example in my work sheet in row 3 in column B, I have a number 79 with a reference: =ABS(CA2) and i would like to swap this number/cell with number 51 that is in row 3, column AO and has a reference =ABS(AY2).
The reference here is irrelevant because I want to swap many numbers between cells.
I just want to know if it is possible to do it in pairs by selecting two numbers at a time and swaping them without doing it manually one by one.
Thanks in advance for your help.
Regards,
John

 

[mtb'r]

Create a VBA userform to collect the addresses of the cells to be switched. Then, use a temporary variable to do the exchange.

If a1 and a2 are the addresses, the exchange code could be something like:
temp = range(a1)
range(a1) = range(a2)
range(a2) = temp

You could also do this without the userform. Just use 2 different inputboxes to collect the address to be exchanged.