Hi All,

Please forgive me if I have posted in the wrong area. This is the first
time I have attempted to create a macro in excel, so please bear with
me.

What I am trying to do is to set up a worksheet with a command button
on it and when it is clicked it will copy values of specific cells in
another workbook and paste them in specific cells within the current
worksheet.

I have tryed to record a macro, done this no problem but it isn't what
I am after. Does anyone have a couple of lines of code that I could
accomplish this.

I can create the command button but I am stuck on the code to carry out
a copy and paste function.

I have done a search on the forum, but I have found nothing there, If
someone could point me in the right direction.


Many Thanks in advance

Andy


---
Message posted from http://www.ExcelForum.com/

Hi All,

I have just managed to figure it out using the following:

Sheets("Sheet1").Select
Sheet1.Range("H3:H10").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste

How would I convert this to select a different workbook that was say in
a location of C:\folder\filename.xls

Many Thanks


---
Message posted from http://www.ExcelForum.com/

Can be shortened to and can be done without any selections from anywhere.

Sheet1.Range("H3:H10").Copy Sheets("Sheet2").Range("A1")

--
Don Guillett
SalesAid Software

"andy F" wrote in message
...
Hi All,

I have just managed to figure it out using the following:

Sheets("Sheet1").Select
Sheet1.Range("H3:H10").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste

How would I convert this to select a different workbook that was say in
a location of C:\folder\filename.xls

Many Thanks


---
Message posted from http://www.ExcelForum.com/