Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Copy and Paste?
I am using Microsoft Office Excel 2003 at work and Microsoft Office Excel
2007 at home. Using either one of these programs I need to transfer more (a lot more) than 1000 short lines of text from the cells into text boxes. Each line of text is in cells A1 through A1000. All the text boxes are adjacent to the cells. To do this with manual cut and paste will take forever. Just wondering if there is some simple code that would allow me to automate doing a €ścopy€ť with one mouse click from the cell containing the text ,and paste into the text box with a second click. (Every other click of the mouse would be a copy/paste) Any thoughts on this would be appreciated. Quin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate copy / paste | Excel Discussion (Misc queries) | |||
automate copy and paste | Excel Discussion (Misc queries) | |||
Automate Copy and Paste | Excel Programming | |||
Any (clever) way to automate ROW:COL in copy/paste??? | Excel Worksheet Functions | |||
Automate Cut/Copy/Paste from Excel Cells | Excel Programming |