Copying the current worksheet to a new worksheet:   Return to List

Cells.Select' Selecting all cells on sheet
Selection.Copy' Copying to clipboard
Worksheets.Add' Adding a new worksheet
Cells.Select' Selecting all the cells
ActiveSheet.Paste' Pasting from the clipboard

See also:
Activate Worksheet by Name
Activates the First Worksheet
Activates Last Worksheet
Adding a Worksheet
Counting and Selecting Worksheets
Deletes Active Worksheet (no save)
Moving worksheet to particular location (i.e., order)
Naming the active worksheet



Note to Webmaster