View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default Creating & Naming a New Worksheet

All I want to do is create and name a new Worksheet,
The below code doesn't quite work, your help would me much appreciated:

sub ad()

worksheets.add
Set worksheets.Name = "Changes"

End Sub