Thread: Tab Names
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default Tab Names

.. then we could just use "WSN" to refer to the sheetname
in formulas within the book ..


Example:

In any sheet, putting in any cell within the sheet: =WSN
will return that sheet's tab name into the cell

Or, applied within a formula:
=VLOOKUP(WSN, ...)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---