I have VBA code that works; however, it's extremely slow. I'm copying 94 sequential columns from one sheet and pasting them to various non-sequential columns in another sheet. Both sheets are located in the same workbook. My solution, albeit possibly clumsy, is to write a single line of copy/paste code for each column. As I said, this solution works, but I'm wondering if there is a cleaner way to write this code, so that the macro would run faster. I'm turning the auto-calculation off before the macro runs, so that option is already exhausted. I pasted a sample of my code below, for illustration.

Please Login or Register  to view this content.
Thank you for any help/advice!!