ExcelBanter - insert my file name in a cell in spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - insert my file name in a cell in spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/245170-insert-my-file-name-cell-spreadsheet.html)

jcb

insert my file name in a cell in spreadsheet

Dave Peterson

insert my file name in a cell in spreadsheet

=cell("Filename",a1)
may be close enough.

Use the cell containing the formula instead of A1.

And the workbook has to be saved at least once.

JCB wrote:

--

Dave Peterson

All times are GMT +1. The time now is 12:29 AM.