The actual copy and paste part I can deal with, the part I need help with is setting up the loop and declarations to "activate" one cell at a time in the following order: A2, B2, C2, D2, E2, F2, A3, B3, C3, D3, E3, F3, and so on. The reason I added the 'paste to application and 'paste to output is because the application is not a spreadsheet, but an actual AS400 database that I use the "APPACTIVATE" and "SENDKEYS" syntax with. The output is a seperate spreadsheet. The operations of copy and paste I can handle, I just need help with the loops and figuring out how to activate each cell in that order.