| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA moving a worksheet to another Workbook
Using a macro, I can easily move a worksheet within a workbook using the line
worksheets("KY").move after:=worksheets(worksheets.count) However, when I try to move the sheet to another workbook using the line below (where tab_name is a text variable), I get a subscript out of range error. Can anyone spot my silly mistake? Workbooks("BV_Analysis_array_4.xls").Worksheets(ta b_name).Move befo=Workbooks("BVInf_10x_consolidator.xls").Wo rksheets(Worksheets.Count) Thanks -- KenY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
| Need help moving a worksheet to another workbook. | Excel Discussion (Misc queries) | |||
| Moving a worksheet to a new workbook when you do not know the name of worksheet | Excel Programming | |||
| Moving Cell Information from one workbook into another workbook | Excel Worksheet Functions | |||
| moving worksheet to another workbook | Excel Programming | |||
Threaded Mode
