If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there a function to print file name/path on a spreadsheet?
|
#2
|
|||
|
|||
Is there a function to print file name/path on a spreadsheet?
Page setup Header/footerCustom footer click the symbols to insert path
and/or filename -- Kind regards, Niek Otten Microsoft MVP - Excel "cchas80860" wrote in message ... |
#3
|
|||
|
|||
Is there a function to print file name/path on a spreadsheet?
cchas80860 wrote: Nothing!
:-} |
#4
|
|||
|
|||
Is there a function to print file name/path on a spreadsheet?
cchas80860 wrote: Nothing!
Look at =CELL("filename") if you aren't talking about headers and footers. |
#5
|
|||
|
|||
Is there a function to print file name/path on a spreadsheet?
If you are going to use CELL("filename"), you should include a cell reference
(any cell will do). Without it, the function returns the name of the last sheet that was recalculated. I always use CELL("filename", A1) now. Also, the workbook must have been saved for the "filename" method of the CELL function to work. Hope this helps, Hutch "Glenn" wrote: cchas80860 wrote: Nothing! Look at =CELL("filename") if you aren't talking about headers and footers. |
Thread Tools | |
Display Modes | |
|
|