If the copied worksheet held a worksheet code sheet in a VBA project, that is also carried into the new workbook.Īn array selection of multiple worksheets can be copied to a new blank Workbook object in a similar manner. The single worksheet retains the Name and CodeName properties of the source worksheet. The newly created workbook holds the Application.ActiveWorkbook property and contains a single worksheet. If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the copied Worksheet object. You cannot specify After if you specify Before. The sheet after which the copied sheet will be placed. You cannot specify Before if you specify After. The sheet before which the copied sheet will be placed. SyntaxĮxpression A variable that represents a Worksheet object. Copies the sheet to another location in the current workbook or a new workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |