Thread: Want Cell A1 equal to File name + Worksheet name
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Want Cell A1 equal to File name + Worksheet name
Using a formula, you can try this provided the workbook is already saved.

=SUBSTITUTE(CELL("filename"),INFO("directory"),)

If this post helps click Yes
---------------
Jacob Skaria


"Lawrence" wrote:

Hi,

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

Lawrence
Reply With QuoteReply With Quote