Thread: Want Cell A1 equal to File name + Worksheet name
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Lawrence Lawrence is offline
external usenet poster
  
Posts: 33
Default Want Cell A1 equal to File name + Worksheet name
Thanks .. it works perfectly..

but just need to do some text function to make it nicer.



"Stefi" wrote:

Try this formula in A1:
=CELL("filename",A1)
Regards,
Stefi

€˛Lawrence€¯ ezt Ć*rta:

Hi,

i want the cell A1 equal to File name + Worksheet name.. is it possible?

Lawrence
Reply With QuoteReply With Quote