Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello. In excel macro, I want to make below statements:
1. adding a sheet whose name is a variable( name is taken from the the cell:sheet1,A1) 2. pasting some rows from another sheet to added sheet. I made the below code, but it doesn't work Sub d() Dim sht As Worksheet Set sht = Sheets("sheet1").Range("A1").Value Sheets("sheet2").Rows("10:20").Copy.Sheets(sht).Ra nge("A10") End Sub Thanks a lot. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add sheet name into a variable. | Excel Worksheet Functions | |||
How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
Variable sheet and Formula Sheet | Excel Discussion (Misc queries) | |||
Sheet Name as a Variable? | Excel Programming | |||
variable in a link where the variable is the name of the sheet | Excel Worksheet Functions |