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/