Copy worksheets from 1 workbook to another
Posted on 2014-03-15
I have a routine that imports worksheets from 1 workbbok into what I will call a master workbook. Part of the code is sheet.copy after:=ThisWorkbook.Sheets(11). Note I will always have 11 static worksheets in the Master workbook. Everyday I will load in 2 worksheets from another workbook into the Master workbook at tab 12 and tab 13 in the Master workbook.
It works fine, but my confusion is if I look at VBA project explorer the number for the worksheet does not correspond to the number of the worksheet when I loop thru worksheets. I assume I can ignore this anamoly as my prcoess works, but I am curious on the difference
Whats the difference between Dim ws As Worksheet and Dim ws As Worksheets
Is there any way when I do sheet.copy after:=ThisWorkbook.Sheets(11) that it will automatically place the worksheet after worksheet 11 without me having to run a separate routine to delete any worksheets found after tab 11 prior to running the line of code :sheet.copy after:=ThisWorkbook.Sheets(11)