Thread: I want a cell to show the current filename automatically.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default I want a cell to show the current filename automatically.
=CELL("filename",B1) in B1. Will display path as well as filename
--
Gary''s Student


"Troy" wrote:

I am trying to set up a spreadsheet for work. I want a specified cell to
automatically show the filename of the current file.
Reply With QuoteReply With Quote