| 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 |
| 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 | |||
Threaded Mode
