Yes, I understand this, but I had hoped that a macro existed (i.e,. one
someone had written) that would take care of all the copying, cutting, and
pasting to and from the third array to preserve the list being overwritten.
Thanks for the reply.
--
Unsophisticated User


"Jim Rech" wrote:

No. If you replace item 1 with item 2 (item = cell or array element) then
item 1 no longer exists unless you preserved it first.

--
Jim
"DrJBN" wrote in message
...
Is there a macro out there where I can select array 1 and array 2 and
switch
their contents without having to copy/cut/past array 2 to array 3, array 1
to
array 2, and then array 3 to array 1?

Thanks,
Byron
--
Unsophisticated User