View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Formula to put Worksheet Name in a Cell

Gary might have mentioned the formula returns #VALUE! until you do a save
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DC Excel User" wrote in message
ups.com...
I'd like to be able to include the name of each worksheet in the body
of the worksheet without having to type it in each time. Is there a
way to use a formula to tell Excel to do this. I've used
=cell("filename",a1) in the past to get the filename in the worksheet,
but I can't find a similar formula for the worksheet name itself.

Thanks.