Help with Swapping column - VBA

[AlexanderBB]

I've recorded a macro, but I'd like to swap the contents of 2 columns without
having the selection show on screen. (The sheet is displayed in a multi column list box and is not 'active').

I do have the number of rows in a variable.

My thinking is to select each column as a range then swap one for another but I'm not sure how to go about it, or if I'll need to store one column temporarily.

Any help much appreciated, thanks !

 

[AlexanderBB]

Hi Rick,

I see what you mean !

I found that bit of code after Googling some time ago ... and it did what I wanted so used it. Never realised there was already one... and yes I can see it now. Feel a bit stupid, but too bad! I suppose there's some good reason I got no 'ambigueous name' error...

Cheers, ABB