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