Interchange multiple cell contents

[Libster78]

Hi,
I need to swap contents of A2:A14 to Q2:Q14 and vice versa simultaneously.

I have found code that wikl swap A2 to Q2 and vice versa but I have various different selections to do and doing 2 cells at a time is taking forever.

Any help gratefully recieved.

thanks
Libby

[DonkeyOte]

Please elaborate on the following:

What drives the swap in the first instance ?

How are the affected cells being populated/altered ? (ie constants, formulas etc...)

By "I have various different selections" presumably you mean you wish to apply similar logic to other "pair areas" ?

If so, where ? ... and: Are there any differences in the underlying mechanisms between the areas or are the answers to the first two questions identical for all affected "areas" ?

[Libster78]

It is exported from outlook and the location is in the subject line and vice versa. Some are correct and some are wrong.

I have attached the sheet.

[DonkeyOte]

We still don't know

a) what determines if a swap of A & Q is necessary in the first instance

b) how you intend to invoke the swap (apply to selection at run time for ex.)

I would suggest you repost the sample with both "before" & "after" sheets and where changes occur between the two specify why.

[Libster78]

If column A has where a course is rather than the type of course it needs to be swapped with Column Q.

If I had before and after sheets then I would have the sheet fixed.

I will remove all that are ok so that it is a complete swap of all column A and all column Q.
Thanks
Libby