View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default How to add a worksheet automatically using macro in xls?

How can I create a macro wherein the actions include adding a new worksheet
and naming the worksheet based on a field in the worksheet?

Ex: 1. Add a worksheet
2. Name the worksheet referencing a field already defined.
3. #1 and #2 is automatic ( ran thru macro)

Please help.