Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Need each new sheet's name to be based on cell value.
Should look something like this (but this one doesnt work) Private Sub Workbook_NewSheet(ByVal Sh As Object) Dim Ws As Worksheet Ws.Name = Ws.Range("e2").Text End Sub |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That's ok. Found one that works. But need to change the code to use
text... This works.... ActiveSheet.Name = Range("e2").Value But, since its a date, I need this to work (cant use /'s in sheet name) ActiveSheet.Name = Text(E2, "mm.dd.yy").Value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto copy cell data from source sheet to another wrkbook sheet | Excel Programming | |||
Auto input data on one sheet based on row selected in another shee | New Users to Excel | |||
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. | Excel Programming | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions |