View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vrzimmerm@hotmail.com is offline
external usenet poster
 
Posts: 28
Default Name a sheet using letters from a string?

I'd like to know how to name the active sheet using the first 6
characters from a string variable. For example: if the string
variable = "Customer" then I want to name the active sheet "Custom"

Many thanks!