Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying worksheet
Hi I want to build a VBA application: I have an excel workbook containing 7 blank worksheet.In my VBA form,I want to enter 7 names of worksheets(not belonging to my workbook),the worksheet corresponding to the first entered worksheet name should be copied to my blank workbook(sheet1),the second entered worksheet name should be copied to my blank workbook(sheet2)... how can i do it? -- engnouna ------------------------------------------------------------------------ engnouna's Profile: http://www.excelforum.com/member.php...o&userid=32203 View this thread: http://www.excelforum.com/showthread...hreadid=519505 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying worksheet
Dim v as Variant
With Userform1 v = Array(.Textbox1.text, .textbox2.text, . . .,.textbox7.text) End With With thisworkbook workbooks("OtherWorkbook.xls").Worksheets(v).Copy _ After:=.Worksheets(.worksheets.count) End With -- Regards, Tom Ogilvy "engnouna" wrote in message ... Hi I want to build a VBA application: I have an excel workbook containing 7 blank worksheet.In my VBA form,I want to enter 7 names of worksheets(not belonging to my workbook),the worksheet corresponding to the first entered worksheet name should be copied to my blank workbook(sheet1),the second entered worksheet name should be copied to my blank workbook(sheet2)... how can i do it? -- engnouna ------------------------------------------------------------------------ engnouna's Profile: http://www.excelforum.com/member.php...o&userid=32203 View this thread: http://www.excelforum.com/showthread...hreadid=519505 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying the active worksheet to another worksheet in the same work | Excel Worksheet Functions | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Multiple Worksheet copying to a master worksheet | Excel Programming | |||
Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming |