Hi All
I have a spreadsheet that is relevant to a particular year
So by convention the year is included in the filename {Descriptive name (year).xlsx}
I extract the year using the Cell("filename") function and all is fine

BUT

If I copy and paste values from this workbook into another workbook the Cell() function returns #Value (presumably because it is using the filename of the workbook into which the info was pasted?).

But why does it do this? MS doc says quite clearly (https://support.microsoft.com/en-us/...f-955d67c2b2cf) it returns the Filename (including full path) of the file that contains reference, as text.

Problem fixed (using a VBA function invoking Thisworkbook.fullname) but thanks for any enlightenment as to why this happens