View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default How do I add NOT insert additional worksheet to existing workbook.

You can do it with VBA code - for example
Set wks = Worksheets.Add(after:=Worksheets(Worksheets.Count) )

But if you have only a few occasions to add worksheets then just drag the
new sheet's tab to the end of the tab list.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Phyllis" wrote in message
...
How can I add - NOT insert - additional worksheet(s) to already existing
workbook?

(as in at the end of the last worksheet, not in between).

Thanks for replies re this.