| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from a worksheet
I want to move the range("A1:C8") in a working worksheet to another excel
file by using VBA. Could someone help. Please show me the procedures. Many Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move data from a worksheet
Alan,
Use code similar to the following. Change the workbook and worksheet names as required: Workbooks("Source.xls").Worksheets("Sheet1").Range ("A1:C8").Copy _ Destination:=Workbooks("Dest.xls").Worksheets("She et1").Range("A1") -- Cordially, Chip Pearson Microsoft Most Valuable Professional - Excel Pearson Software Consulting, LLC www.cpearson.com (email on web site) "AlanW" wrote in message ... I want to move the range("A1:C8") in a working worksheet to another excel file by using VBA. Could someone help. Please show me the procedures. Many Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move data from a worksheet
Hi Mr. Pearson
It is working now. Thank you very very much. "Chip Pearson" 來函： Alan, Use code similar to the following. Change the workbook and worksheet names as required: Workbooks("Source.xls").Worksheets("Sheet1").Range ("A1:C8").Copy _ Destination:=Workbooks("Dest.xls").Worksheets("She et1").Range("A1") -- Cordially, Chip Pearson Microsoft Most Valuable Professional - Excel Pearson Software Consulting, LLC www.cpearson.com (email on web site) "AlanW" wrote in message ... I want to move the range("A1:C8") in a working worksheet to another excel file by using VBA. Could someone help. Please show me the procedures. Many Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move data from one worksheet to another. | Excel Worksheet Functions | |||
| How do I move data from one worksheet to another? | Excel Discussion (Misc queries) | |||
| Move select data to another worksheet | Excel Discussion (Misc queries) | |||
| How to move data on worksheet | Excel Discussion (Misc queries) | |||
| Selecting data to move to new worksheet | Excel Programming | |||
Linear Mode
