View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
 
Posts: 118
Default ActiveSheet.CodeName?

Charlotte...Use "name" instead of "codename"...Ron

ActiveWorkbook.Worksheets.Add
WS_CodeName = ActiveSheet.Name