| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula returning the worksheet name
Hi everyone! Is it possible to write a formula, which returns the name of the worksheet as a value of the cell? Waiting for your comments, Dobrin -- dminkov ------------------------------------------------------------------------ dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757 View this thread: http://www.excelforum.com/showthread...hreadid=557305 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula returning the worksheet name
This UDF will do it
Function MySheet() Application.Volatile MySheet = ActiveSheet.Name End Function Call it with =mysheet() best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "dminkov" wrote in message ... Hi everyone! Is it possible to write a formula, which returns the name of the worksheet as a value of the cell? Waiting for your comments, Dobrin -- dminkov ------------------------------------------------------------------------ dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757 View this thread: http://www.excelforum.com/showthread...hreadid=557305 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula returning the worksheet name
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dminkov" wrote in message ... Hi everyone! Is it possible to write a formula, which returns the name of the worksheet as a value of the cell? Waiting for your comments, Dobrin -- dminkov ------------------------------------------------------------------------ dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757 View this thread: http://www.excelforum.com/showthread...hreadid=557305 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula returning the worksheet name
The following formula will return path+filename+worksheet name
=CELL("filename",A1) So, therefore, you can use this formula to get the worksheet name alone =MID(CELL("filename",A1),1+FIND("]",CELL("filename",A1)),31) Note that the 31 value above is because a worksheet name can have a max length of 31. These formulas point to cell A1 in the current sheet, but can point to any cell. Also, it is possible for them to point to cells in other sheets and the formulas will return those other worksheet names. The formula can also point to its own cell (i.e. the formula can be in A1 and point to A1). Bob Phillips wrote: See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "dminkov" wrote in message ... Hi everyone! Is it possible to write a formula, which returns the name of the worksheet as a value of the cell? Waiting for your comments, Dobrin -- dminkov ------------------------------------------------------------------------ dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757 View this thread: http://www.excelforum.com/showthread...hreadid=557305 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula returning the worksheet name
The UDF made exactly what I wanted, thank you , Beranrd :) -- dminkov ------------------------------------------------------------------------ dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757 View this thread: http://www.excelforum.com/showthread...hreadid=557305 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Worksheet from Formula | Excel Worksheet Functions | |||
| Returning a cell's formula in a different cell | Excel Worksheet Functions | |||
| What is the formula to reference a cell in a different worksheet? | Excel Worksheet Functions | |||
| Cannat paste that macro formula onto a worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
