30th June 2009, 02:15 PM
|
 |
The Code Cage Staff
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient with Excel
|
|
Join Date: Dec 2008
Location: Mississauga Canada
Posts: 434
Thanks to others: 10
Thanked 14 Times in 14 Posts
Chats: 235
Rep Power: 7
2 Top Tips
|
|
Re: How do I display the filename and path in a cell?
------ Register to get rid of these "In Post" ads! ------
Try:
=CELL("filename",$A$1)
this gives the entire path (including the sheetname).
__________________
Where there is a will there are many ways.
The Code Cage
Did you find this post helpful?
 |
|