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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Sheet to sheet code Type Mismatch 6
Hyperlink to Same sheet but after that want to hide link sheet 1
Array with many cells from a row but not in order or together 11
How to activate Sheet2? 5
range name define on non active(focused) sheet 10
Object variable or with Block variable not set 9
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Top