This is way easier than my suggested approach!
--
Wag more, bark less


"RagDyer" wrote:

Say you want to swap A1 to A10 with B1 to B10, and leave A11 to B100
untouched.

Select A1:A10,
Right click and choose "Cut",
Right click in C1 and choose "Insert Cut Cells",

And you're done!

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Susan" wrote in message
...
I'd like to be able to switch the contents of cells, say between column A
to
column B, without having to move the contents of column A to C, moving
contents of B to A and then moving contents from C to B. Is there an easy
way
to do this?