Moves the worksheet named Homes from the workbook named Planning.xls to the workbook named Building Schedule.xls, inserting the worksheet before the first existing worksheet in the workbook : Workbooks « Excel « VBA / Excel / Access / Word
- VBA / Excel / Access / Word
- Excel
- Workbooks
Moves the worksheet named Homes from the workbook named Planning.xls to the workbook named Building Schedule.xls, inserting the worksheet before the first existing worksheet in the workbook
Sub move()
Workbooks("Planning.xls").Sheets("Homes").Move , _
Before:=Workbooks("Building Schedule.xls").Sheets(1)
End Sub
Related examples in the same category