ExcelBanter - name of a sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - name of a sheet (https://www.excelbanter.com/excel-programming/276071-name-sheet.html)

René Kerstgens

name of a sheet

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

All times are GMT +1. The time now is 02:57 AM.