Need VBA Code Amended to Paste in the Next Available Column

Hello,

With the code shown below I am able to cut and past data via macro. It transposes the data and works perfectly, however, I would like this code to find the next available column in the "ActiveSheet" and paste, effectively appending to the existing data. In other words, if what is shown below pastes into column "L", I'd like the next iteration to find that column "M" is empty and paste the data there.

Thanks,

Please Login or Register  to view this content.

Awesome, works like a charm, many thanks!