| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Name change
Got stumped ont hsi one :-( Trying to rename a sheet to what ever
value is in a certain cell. This returns an error, and the help files did not help much,,,, Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim cRow As Long, cCol As Long cRow = Target.Row cCol = Target.Column If (cCol = 14 And cRow = 5) Then ActiveSheet.Name = Target.Value End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
Threaded Mode
