I have two workbooks open in Excel. WorkbookName1 and WorkbookName2.

In Workbook2 i want to place with vba the name of Workbook1 in a variable.

After that i want to copy the range A10:b20 from Workbook2 to Workbook1

How to do this???

thanks in advance

René Kerstgens