| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet name = cell value
I need to set a Worksheet's name equal to cell B3's
value. If I could set it to a Portion of B3's value that would be better, e.g. Mid(B3,9,20) any help will be appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet name = cell value
Hi:
ActiveSheet.Name = Mid(Range("B3").Value,9,20) Regards, Vasant. "MC" wrote in message ... I need to set a Worksheet's name equal to cell B3's value. If I could set it to a Portion of B3's value that would be better, e.g. Mid(B3,9,20) any help will be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cell from one worksheet to another worksheet in exel | Excel Discussion (Misc queries) | |||
| How do I take a cell in one worksheet and add it into the formula in a different worksheet in the same workbook? | Excel Worksheet Functions | |||
| How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
![MC[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
