Moving Sheets

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

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext