Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using the name of the worksheet as argument
I need to use the name of the currrent worksheet as an argument for a function in that worksheet. Is there a way to get that name through some system variable or smthg and use it in a LOOKUP, IF or any other function for that matter ? I searched the forums but no clue so far. Any help appreciated. -- radulucian ------------------------------------------------------------------------ radulucian's Profile: http://www.excelforum.com/member.php...o&userid=29393 View this thread: http://www.excelforum.com/showthread...hreadid=491042 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using the name of the worksheet as argument
after looking it up for hours, i found the answer myself in less then 5 minutes after posting this. for the records, here it is: The Cell function returns information about the formatting, location, or contents of the upper-left cell in a reference. To get the sheet name: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) To get the workbook name: =MID(CELL("filename"),FIND("[",CELL("filename"))+1,(FIND("]",CELL("filename"))+1)-FIND("[",CELL("filename"))-2) To get the path address & workbook name: =CELL("filename") To get the path address: =MID(CELL("filename"),1,FIND("[",CELL("filename"))-1) oh, got it from exceltip.com -- radulucian ------------------------------------------------------------------------ radulucian's Profile: http://www.excelforum.com/member.php...o&userid=29393 View this thread: http://www.excelforum.com/showthread...hreadid=491042 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using the name of the worksheet as argument
You should add a reference to each =cell("filename").
=MID(CELL("filename",a1),FIND("]",CELL("filename",a1))+1,255) You may find that you get the wrong name if you don't include that. radulucian wrote: after looking it up for hours, i found the answer myself in less then 5 minutes after posting this. for the records, here it is: The Cell function returns information about the formatting, location, or contents of the upper-left cell in a reference. To get the sheet name: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) To get the workbook name: =MID(CELL("filename"),FIND("[",CELL("filename"))+1,(FIND("]",CELL("filename"))+1)-FIND("[",CELL("filename"))-2) To get the path address & workbook name: =CELL("filename") To get the path address: =MID(CELL("filename"),1,FIND("[",CELL("filename"))-1) oh, got it from exceltip.com -- radulucian ------------------------------------------------------------------------ radulucian's Profile: http://www.excelforum.com/member.php...o&userid=29393 View this thread: http://www.excelforum.com/showthread...hreadid=491042 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |