insert new sheet

  1. J

    Add New Worksheet after the Last Worksheet

    Hello, I am trying to get the new worksheet I am adding to be placed after the last workbook. I want to replace the "Add" in the line: "Set Dest_Sh = ActiveWorkbook.Worksheets.Add." with "Add(After:=mainWB.Sheets(mainWB.Sheets.Count)). But, it is not working for me. Any thoughts...
  2. H

    Code to always add new sheet after the last sheet

    Hi, i need some clue to do the following: whenever the macro is run, it will add a new worksheet as the last sheet, nomatter how many existing worksheets there are (i.e. the right most sheet tab will be this new added sheet) Sub AddLastSheet() Dim ws as Worksheet Set ws = worlsheets.Add...

Some videos you may like

This Week's Hot Topics