| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Function or VBA code for worksheet's name
Dear all Excel experts ... I wonder whether there is an Excel built-in function or VBA code (please give me an example code and how to create it) for showing worksheet's name (text) in a cell? Let say I have cell A1. So I want A1 cell will refer to "sheet1" worksheet's name (worksheet tab's name). And if I change "sheet1" name to "john", the cell A1 will change to "john". Thank so much in advance ... I look forward to getting a quick response .... Hendra  -- hendra ------------------------------------------------------------------------ hendra's Profile: http://www.excelforum.com/member.php...o&userid=35516 View this thread: http://www.excelforum.com/showthread...hreadid=571237 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Function or VBA code for worksheet's name
No need for VBA.
See Bob Phillips' site for worksheet formulas. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Sun, 13 Aug 2006 21:57:43 -0400, hendra wrote: Dear all Excel experts ... I wonder whether there is an Excel built-in function or VBA code (please give me an example code and how to create it) for showing worksheet's name (text) in a cell? Let say I have cell A1. So I want A1 cell will refer to "sheet1" worksheet's name (worksheet tab's name). And if I change "sheet1" name to "john", the cell A1 will change to "john". Thank so much in advance ... I look forward to getting a quick response .... Hendra |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Function or VBA code for worksheet's name
Thank so much for your help Gord Dibben. I really appreciate it. Hendra -- hendra ------------------------------------------------------------------------ hendra's Profile: http://www.excelforum.com/member.php...o&userid=35516 View this thread: http://www.excelforum.com/showthread...hreadid=571237 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
| FUNCTION GETPIVOTDATA MICROSOFT EXCEL 2003 VS EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
| FUNCTION GETPIVOTDATA EXCEL 2003 v EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
| Improve Excel Help Text - Make easier to Find Function Refs | Excel Worksheet Functions | |||
| "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Linear Mode
