Thread: Can I have the TAB name be a calculated field...?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Keith74 Keith74 is offline
external usenet poster
  
Posts: 120
Default Can I have the TAB name be a calculated field...?
Well i think the code would be soming like

Sheets("Sheet1").Name = activesheet.cells(rowno, colno).value &
Format(somedate, "d/m/yy")

Stick under the desired event and simmer gently for 30 mins

hth

Reply With QuoteReply With Quote