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