View Single Post
  #5   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

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