is there any formula that put the sheet name in the same workbook any column
or row

Take a look he

http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
xyz wrote:

is there any formula that put the sheet name in the same workbook any column
or row

"xyz" wrote:
is there any formula that put the sheet name
in the same workbook any column or row

One way is to use INDIRECT with this Harlan-inspired technique to return the
active sheetname ..

Note: Workbook must be saved first

Click Insert Name Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1"Â*)))+1,32)
Click OK

The above defines WSN as a name we can use to refer to the sheetname in any
sheet. It will auto-extract the sheetname implicitly.

Eg, if you enter: =WSN in any sheet, any cell, it'll return the sheetname in
that cell.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---