Can you have cells "trade places"?

J

Jimmy

I dont know if this is possible, but I want to be able to move a cell on top of another cell and have them trade places instead of just delete the existing cell. Is this possible?
 
C

CLR

You could record a Macro to move/copy A1 to C1 and then move/copy B1 to A1,
and then move/copy C1 to B1..........

Vaya con Dios,
Chuck, CABGx3


Jimmy said:
I dont know if this is possible, but I want to be able to move a cell on
Click to expand...
top of another cell and have them trade places instead of just delete the
existing cell. Is this possible?
 
Top