I have two sheets open in Excel. SheetName1 and SheetName2.

In Sheet2 i want to place with vba the name of sheet1 in a variable.

After that i want to copy the range A10:b20 from sheet2 to sheet 1

How to do this???

thanks in advance

René Kerstgens