| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy & paste command button
I need some HELP.....
I would like to create a command button that would copy a range of pre-selected cells and paste them to the next open line of cells in another worksheet, the go back and delete the data of the original selected range. I have a just started to learn VBA any could sure use some examples. Any Ideas....... Thank you, Dale |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy & paste command button
Hi Dale
just a a starting point: http://www.rondebruin.nl/copy5.htm -- Regards Frank Kabel Frankfurt, Germany "RENEE RINEHART" schrieb im Newsbeitrag ... I need some HELP..... I would like to create a command button that would copy a range of pre-selected cells and paste them to the next open line of cells in another worksheet, the go back and delete the data of the original selected range. I have a just started to learn VBA any could sure use some examples. Any Ideas....... Thank you, Dale |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy & paste command button
I think Frank mean this
http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Frank Kabel" wrote in message ... Hi Dale just a a starting point: http://www.rondebruin.nl/copy5.htm -- Regards Frank Kabel Frankfurt, Germany "RENEE RINEHART" schrieb im Newsbeitrag ... I need some HELP..... I would like to create a command button that would copy a range of pre-selected cells and paste them to the next open line of cells in another worksheet, the go back and delete the data of the original selected range. I have a just started to learn VBA any could sure use some examples. Any Ideas....... Thank you, Dale |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy & paste command button
Hi Ron
correct. §$%$§ copy+paste thanks for the correction -- Regards Frank Kabel Frankfurt, Germany "Ron de Bruin" schrieb im Newsbeitrag ... I think Frank mean this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Frank Kabel" wrote in message ... Hi Dale just a a starting point: http://www.rondebruin.nl/copy5.htm -- Regards Frank Kabel Frankfurt, Germany "RENEE RINEHART" schrieb im Newsbeitrag ... I need some HELP..... I would like to create a command button that would copy a range of pre-selected cells and paste them to the next open line of cells in another worksheet, the go back and delete the data of the original selected range. I have a just started to learn VBA any could sure use some examples. Any Ideas....... Thank you, Dale |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy & paste command button
Ron & Frank,
Thanks....I'll give it a try............. Dale Rinehart "Frank Kabel" wrote in message ... Hi Ron correct. §$%$§ copy+paste thanks for the correction -- Regards Frank Kabel Frankfurt, Germany "Ron de Bruin" schrieb im Newsbeitrag ... I think Frank mean this http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Frank Kabel" wrote in message ... Hi Dale just a a starting point: http://www.rondebruin.nl/copy5.htm -- Regards Frank Kabel Frankfurt, Germany "RENEE RINEHART" schrieb im Newsbeitrag ... I need some HELP..... I would like to create a command button that would copy a range of pre-selected cells and paste them to the next open line of cells in another worksheet, the go back and delete the data of the original selected range. I have a just started to learn VBA any could sure use some examples. Any Ideas....... Thank you, Dale |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cell by command button | Excel Worksheet Functions | |||
| Use macro(command button) paste special in 2nd sheet | Excel Worksheet Functions | |||
| How do I add a command button on a worksheet to "paste" from the . | Excel Worksheet Functions | |||
| How do I add a command button on a worksheet to "paste" from the . | Excel Worksheet Functions | |||
| copy and delete command button | Excel Programming | |||
Linear Mode
