Naming a cell

[Curtis]

I believe there is a way to name a cell in a worksheet to equal the worksheet
name but I cannot recall

Is there?

Thanks

 

[Jacob Skaria]

Try
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

If this post helps click Yes

 

[Eduardo]

Hi,
for the worksheet name use Jacob suggestion if you want the workbook name use

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

 

[Jacob Skaria]

Make sure you save the workbook..or else the formula will return #VALUE! error

If this post helps click Yes
---------------
Jacob Skaria

Try
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)

If this post helps click Yes
---------------
Jacob Skaria

I believe there is a way to name a cell in a worksheet to equal the worksheet
name but I cannot recall

Is there?

Thanks

 

[ryguy7272]

Take a look at this:
http://www.ozgrid.com/VBA/return-sheet-name.htm

Here are a few more to ponder
http://www.exceltip.com/st/Cell_Function_Returns_Sheet_Name,_Workbook_Name_and_Path/180.html

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

Hi,
for the worksheet name use Jacob suggestion if you want the workbook name use

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

I believe there is a way to name a cell in a worksheet to equal the worksheet
name but I cannot recall

Is there?

Thanks