Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto name each new sheet based on cell value
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
|
|||
|
|||
auto name each new sheet based on cell value
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 | |
|
|
Similar Threads | ||||
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 |