View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Price Price is offline
external usenet poster
 
Posts: 6
Default Macro to insert and name a new worksheet

I need a macro to insert a new sheet in the n-3 position where n is
the total number of worksheets. And I need to name the sheet the
name that is in column A of the current row. Example: A1 has Product
A then I hit a button in column G1 and it creates a page called
Product A Plan in the n-3 location.

Your help is appreciated.