Cell("filename") doesn't update to new filename when do save as.
And you'll want to add a range reference to that formula:
=cell("Filename",a1)
Unless you want to show the name of the workbook/worksheet that was active when
excel recalculated.
Louis wrote:
Is there any way to set Excel to automatically do that?
--
Dave Peterson
|