Moving an existing worksheet
The Copy and Move methods of the Worksheet object allow you to copy or move one or more worksheets in a single operation.
Both the methods have two optional parameters that allow you to specify the destination of the operation.
The destination can be either before or after a specified sheet.
If you do not use one of these parameters, the worksheet will be copied or moved to a new workbook.
Copy and Move do not return any value or reference.
The first sheet created by a Copy (or resulting from a Move) will be the immediatley active after the operation.
Sorting your worksheets into alphabetical order
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext