Thread: name the sheet the same as the file name
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default name the sheet the same as the file name
Sheet names are limited to 31 characters (through xl 2003 afaik). You
could try something like this...

ActiveSheet.Name = Left(ThisWorkbook.Name, 31) 'or right as far as
that goes

Cliff Edwards
Reply With QuoteReply With Quote