Cell("filename") doesn't update to new filename when do save as.

  • Thread starter Thread starter Guest
  • Start date Start date
If you done a SaveAs, the formula will update as soon as any calculation
occurs on the worksheet. Otherwise, touch F9.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
set filename to <filename-date> on open 2
Need help in VBA for embedded object in excel 1
Filename from a Cell 7
=CELL("filename") VOLATILE? 6
=cell("filename") in multiple places 2
Vlookup Cell Contents Filename 1

Back
Top