Copy the active sheet

[Mary Frances]

I use a workbook for a medical equipment with several sheets. The first sheet contains all of the supplies needed for that instrument. If two instruments are needed, we copy/paste/create a copy in the same workbook. I created a macro with a button that will copy the first sheet into a new workbook, leaving the original in place. But if I have a Sheet 2, the macro refers to Sheet 1 . For example Sheet 1 has the button, and I copy/paste/create a copy, creating Sheet 2, and click the macro button on Sheet 2, the macro goes back to Sheet 1 to copy.

Visual basic has:

Please Login or Register  to view this content.

as the first line. Is there something like

Please Login or Register  to view this content.

that I could use?

[VBA Noob]

Mary,

Please read forum rules below. I have wrapped your code and move to programming.

Try

Please Login or Register  to view this content.

VBA Noob

[Mary Frances]

Thank You. That is what I needed.