| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab sheet name
I have this code,
Private Sub Worksheet_Calculate() Me.Name = Range("b36").Value End Sub that name the sheet tab based on cell B36. The problem is when I copy the sheet and I enter the same name in the duplicate sheet and the previous sheet I get an error. Is there a way to add a nuber at the end of the duplicate sheet. example: 1st sheet name = Round 2nd sheet name = square 3rd sheet name = round(2) all sheet have the same calculations. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
