Thread: Is it possible to have a cell just quote the worksheet name?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default Is it possible to have a cell just quote the worksheet name?
This, in any cell will return the SheetName, once the file has been saved.

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

Vaya con Dios,
Chuck, CABGx3




"DannyS" wrote:

Ie. My workbook has 5 worksheets, England, Scotlans etc

Can I have cell A7 of each sheet just quote the name?

Thanks!
Reply With QuoteReply With Quote