"File Name" in the spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to use the File name inside tyhe spreadsheet, but I can not find how
to link it to a cell. I found that I can use it easily in footer anf header
to print out, but I need to use it as data and manage that information. Some
body know how to link the file name and set it inside the spread sheet????

Thank you!
 
Thanks Pranav, very helpful!!!
--
Albert


Pranav Vaidya said:
Hi Albert,

use CELL worksheet function as
=CELL("filename",A1)

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top