View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob P Rob P is offline
external usenet poster
 
Posts: 15
Default Adding new worksheet BEFORE 1st worksheet

I am calling several macros

the last of which is:

Sub summary()
Sheets.Add.Name = "1 day moves"
Sheets.Add.Name = "3 day moves"
End Sub

this inserts the 2 new worksheets BEFORE the very last sheet

how can I insert these BEFORE a specific worksheet called "template"

thank you
Rob