Hi
I have been trying to do this for quite some time but i can’t seem to find how to do…
I intent to incrementally copy and paste cells from Microsoft Excel to another application.
All the cells that I require start at A1 and go down to A4300. I would like to copy 50 cells of A at a time.
e.g.
Copy A1 to A50 then open the other app and paste, then come back
copy A51 to A100 then …
copyA101-A150 then… repeat until all the active cells are completed or i reach cell A4300.
I just need help with the part of incrementally copying in Excel.
Can anyone suggest any ideas? provide a basic applescript?
I have created a script to click shift down and copy x50 times then paste on the other application. But the problem is that when i come back to Excel and click down the selection does not start at Cell A51 it starts at Cell A2 and as a result copies 50 cells from A2 which had already been copied in the first attempt starting at A1.
Many thanks.