Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Moves the worksheet named Homes from the workbook named Planning xls to the workbook named Building Schedule xls, inserting the work

Sub move()     Workbooks("Planning.xls").Sheets("Homes").Move , _        Before:=Workbooks("Building Schedule.xls").Sheets(1) End Sub