Thread: nameing a worksheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default nameing a worksheet
You can also refer the sheet using the Sheet name or the Sheet index number.

Sheets("Sheet1").Name = "<New Name"
Sheets(1).Name = "<New Name"

If this post helps click Yes
---------------
Jacob Skaria


"Lost" wrote:

Is it possible to name a sheet based on 2 cell values with either a formula
or VB?

Example
A1=4/20/09
B2=Help

worksheet name is Help 4/20/09

Reply With QuoteReply With Quote