Macro to swap selected cell contents

Dear All

I am looking for a short macro that swaps the cell contents of selected cells.

For example, I select cells G3, G6, G15, G26 > then I run the macro > it swaps them with K3, K6, K15, K26

BEFORE:

Screenshot 2017-11-05 18.11.46.png

AFTER:

Screenshot 2017-11-05 18.11.53.png

Thank you !!

Here, try this:

Please Login or Register  to view this content.

Thanks guys !! Both work great !!

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.