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

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

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


"Curtis" wrote:

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

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

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


"Jacob Skaria" wrote:

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

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


"Curtis" wrote:

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

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)

"Curtis" wrote:

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

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_Func..._Path/180.html

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


"Eduardo" wrote:

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)

"Curtis" wrote:

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