Quote Originally Posted by Rasm View Post
Thanks --- I have changed my code so it loops -- one range at a time-- but what a pain - I have to copy columns that are not contiguous -- also my destination is not the same columns --- I appreciate the offer of code. But I got it working now. I have approx 700 columns of data --- so I am considering to insert a row and then place a number in that row represent the order that I want to copy the data --- I know how to sort rows -- But have never sorted columns. I will make a separate post asking how to sort on rows
If you provide the details of your setup, what ranges comprise your non-contiguous areas, why/how you identify them, what you are doing with them, etc., etc., then perhaps we can offer some more condensed coding than it sounds like you may have currently. Also posting the code you have now, in conjunction with the above details, might help us help you further as well. VB coding can do marvelous things, and in a lot of cases, in sometimes surprisingly compact code procedures, but for anyone to help you to do that, we need details.