Can this small bit of code be combined to one line of code?

Hi Wedge120,

I have two workbooks open and have two methods to do what you ask. The syntax is the hard part. What VBA wants is always a trial and error event for me.

I'm taking the stuff on Row 4 on Sheet1 of Workbook 2 and copying it to Workbook1 Sheet1 Row 9.
The first way is to use the Copy ....:=Destination method and it looks like:

Please Login or Register  to view this content.

A second way is to simply copy over the stuff on the left hand side of the equation with the stuff from the right side of the equations. It looks like this:

Please Login or Register  to view this content.

Note I had to put .Value after the Rows - I'm not positive why but trial and errored it to work.
In your example above I think I'm close to suggest

Please Login or Register  to view this content.

If you have already selected what you want to copy then Selection.copy should work.
I'm not sure you can use the workbook name of "workbook" as it might be a reserved word. Also you need to be specific about which worksheet in the workbook your are going to copy onto.

hope that helps.