Move data from a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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("Sheet1").Range("A1")


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Hi Mr. Pearson

It is working now. Thank you very very much.

"Chip Pearson" 來函：
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel VBA - Problem with Closing Print Preview 0
Excel Moving data to sheet2 from sheet1 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to reference a cell from anther workbook without opening it 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top