Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming sheets
In
Private Sub CommandButton1_Click() I have written this code segment to rename "Sheet1" = to the cell value in "L1" on the same sheet. The Private Sub is located in a different sheet, but in the same workbook. Worksheets("Sheet1").Activate With Worksheets("Sheet1") .Sheet.Name = Range("L1") End With It fails at the third line with "error 438" object does'nt support this property or method. Any ideas anyone Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming Sheets | Excel Discussion (Misc queries) | |||
renaming sheets | Excel Programming | |||
renaming all work-sheets at once | Excel Discussion (Misc queries) | |||
Renaming sheets | Excel Programming | |||
renaming sheets | Excel Programming |