name of a sheet

  • Thread starter René Kerstgens
  • Start date
R

René Kerstgens

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
 
Top