VBA - Insert new sheet as the last sheet

  • Thread starter Thread starter MoonWeazel
  • Start date Start date
M

MoonWeazel

Good Morning All,

I have a spreadsheet with a lovely piece of code that inserts a shee
into the workbook via a button.

The sheet is inserted to the left of the sheet with the button.

Is there a way to get the sheet to be inserted to the right of th
sheet with the button?

I am probably being a bit thick - I apologise in advance!!

Thanks,

MoonWeaze
 
Hi Moon Weazel,


ActiveWorkbook.Worksheets.Add After:=ActiveSheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top