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

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

is there any formula that put the sheet name in 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

is there any formula that put the sheet name in 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
---