Consulting

Results 1 to 2 of 2

Thread: Copy active workbook

  1. #1

    Copy active workbook

    Hi,hope you are doing great
    I need an Excel VBA code that makes the same copy of the active sheet.

  2. #2
    Moderator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,190
    Location
    If it is just to create a copy of the active sheet then:
    Sub test()
        ActiveSheet.Copy
    End Sub
    In the title you have workbook and in the text you have active sheet, the workbook is the thing that houses the worksheets.
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved

    Excel 365, Version 2403, Build 17425.20146

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •