View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kai Cunningham[_2_] Kai Cunningham[_2_] is offline
external usenet poster
 
Posts: 13
Default Macro to create a new worksheet that is a copy of an existing one?

I have created a button that I want to assign a macro to that will take the
information in a cell and make it the name of a new worksheet. This
worksheet needs to be a copy of an existing worksheet (#2 in position in the
line of worksheets currently) but with the name the user enters in the box
provided. Any suggestions?
-Kai