Thanks for your reply. If B has lets say 10 cells and A has 5 cells then after the swap column A will have 10 cells and column B will have 5 cells. Thanks once again
Maybe you just don't know what your code actually does?? AFAIK moving the entire column is not 5 or 10 cells, or maybe I just have poor english skills?.
Post#4:
Maybe you just don't know what your code actually does?? AFAIK moving the entire column is not 5 or 10 cells, or maybe I just have poor english skills?.
My code will swap ONLY the range of cells specified. And will begin at top left cell per what seemed to be the OP's request and subsequent elaboration. I did not ask about overlapping ranges only assumed they would not overlap.
Thanks for your reply. If B has lets say 10 cells and A has 5 cells then after the swap column A will have 10 cells and column B will have 5 cells. Thanks once again
My code will swap ONLY the range of cells specified. And will begin at top left cell per what seemed to be the OP's request and subsequent elaboration. I did not ask about overlapping ranges only assumed they would not overlap.
???
Anyway, let's wait to see what fits in with the OP's requirements.
It may be that I have misread the requirements or the OP only wants to add to her knowledge of VBA arrays - in which case my suggestion is inappropriate.