Copy an entire worksheet to a new worksheet in Excel 2010

by

It is simpler just to run an exact copy like below to put the copy in as the last sheet

Sub Test()
Dim ws1 As Worksheet
Set ws1 = ThisWorkbook.Worksheets("Master")
ws1.Copy ThisWorkbook.Sheets(Sheets.Count)
End Sub

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. Getting ScriptControl to work with Excel 2010 x64
  3. Pop up the Excel Statusbar?
  4. Get list of Excel files in a folder using VBA [duplicate]
  5. When one should use Set [e.g for SpecialCells return value]?
  6. Should I turn .CutCopyMode back on before exiting my sub procedure?
  7. Determine if cell contains data validation
  8. Sheet protection: UserInterFaceOnly gone
  9. VBScript – How to make program wait until process has finished?
  10. How to highlight a cell using the hex color value within the cell?
  11. Removing special characters VBA Excel
  12. Open an Excel file from SharePoint site
  13. VBA recognizing workbook by partial name
  14. Excel VBA wildcard search
  15. How do I loop an excel 2010 table by using his name & column reference?
  16. Excel VBA Project has generated multiple Workbook objects
  17. VBA macro that search for file in multiple subfolders
  18. So, I have 6 “master” files to then divide into 40 separate files
  19. Application.Match gives type mismatch
  20. Count and Highlight keywords within phrases
  21. Transpose a range in VBA
  22. Detect merged cells in VBA Excel with MergeArea
  23. Parse HTML content in VBA
  24. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  25. VBA EXCEL To Prompt User Response to Select Folder and Return the Path as String Variable [duplicate]
  26. How to use VBA SaveAs without closing calling workbook?
  27. Removing the password from a VBA project
  28. Missing VBA compiler message for wrong method name
  29. Is there a way to make UDF that gives a description like the native Excel functions have when user clicks the Fx button?
  30. Delete Hidden/Invisible Rows after Autofilter Excel VBA

Leave a Comment