| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to place sheet name in cell
I am using a formula: “Sheet "& MID(CELL("filename",B11),FIND("]",CELL("filename",B11))+2 LEN(CELL("filename",B11))-FIND("]",CELL("filename",B11))) “ to place part of the worksheet name in a cell. However because o formatting requirements I cannot use a formula. Can I do this usin VBA? Then I could have the macro run each time the workbook is close to keep the cell up to date. Thanks Rober -- Hammer_75 ----------------------------------------------------------------------- Hammer_757's Profile: http://www.excelforum.com/member.php...nfo&userid=741 View this thread: http://www.excelforum.com/showthread.php?threadid=40003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use a range value in place of sheet name | Excel Discussion (Misc queries) | |||
| Automatically place text in one cell into cell in another sheet | New Users to Excel | |||
| how do I place the sheet tab name in my spreadsheet by formula? | Excel Worksheet Functions | |||
| Is there a formula that will place the sheet name in a cell? | Excel Worksheet Functions | |||
| How do i place a graphic BEHIND an excel sheet? | Excel Programming | |||
![Hammer_757[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
