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

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

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