Thread: Want Cell A1 equal to File name + Worksheet name
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Want Cell A1 equal to File name + Worksheet name
You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated.
Post if you can tell us what form would be nicer for xou!
Stefi

€˛Lawrence€¯ ezt Ć*rta:

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