Thread: How can I get a worksheet name appear in a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default How can I get a worksheet name appear in a cell?
Hi Gary

Look here
http://www.mvps.org/dmcritchie/excel...c.htm#BuildTOC


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Gary" wrote in message ...
I have 199 worksheets and I would like to have a summary page that displays
the sheet name in column A . I'm looking for a script or how to reference
the worksheet name so I can have a function auto populate the table names
from A2..A200

Thanks


Reply With QuoteReply With Quote