| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem renaming worksheet
The code below is intended to change the name of the Active Worksheet to the
Value in cell A4. But I get an "object or With variable not set" Private Sub Worksheet_Change(ByVal Target As Range) Dim Sh As Worksheet If Target.Address = "$A$4" Then Const sStr As String = "A4" ActiveSheet.Name = Sh.Range(sStr).Value End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with renaming work sheet name | Excel Discussion (Misc queries) | |||
| Problem renaming a worksheet tab | Excel Discussion (Misc queries) | |||
| Problem renaming worksheets | Excel Discussion (Misc queries) | |||
| renaming problem | Excel Worksheet Functions | |||
| Workbook crashes after renaming a worksheet - References problem? | Excel Programming | |||
Threaded Mode
