PDA

View Full Version : [SOLVED:] Copy active workbook



KAMRAN AJ
03-13-2023, 11:33 PM
Hi,hope you are doing great
I need an Excel VBA code that makes the same copy of the active sheet.

georgiboy
03-13-2023, 11:38 PM
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.