| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
initiating a macro
does anybody know why this doesn't work:
Private Sub Workbook_NewSheet(ByVal Sh As Object) Set rng = Worksheets("Sheet1").Range("A1") i = 1 For Each sht In Worksheets rng(i, 1) = sht.Name i = i + 1 Next End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| automatic macro update | Excel Worksheet Functions | |||
| Date macro | Excel Discussion (Misc queries) | |||
| Can't get simple macro to run | Excel Worksheet Functions | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Threaded Mode
