Updating cell in excel
Since a UDF cannot do this, I tried using Event calls.
If I record the macro to go to a recent file, for example Window 1 (filename), the code that I get in VBA is Windows("filename"). This doesn't translate to when I have two different workbooks with different filenames open. - Michael I was wondering if there is a way of getting a macro to open the "save as" dialogue box and then have it fill in the "file name" field.
On the other hand, Application events such as Functions cannot modify cells, correct ?
They can only return values but when we want function execution to actually modify cells, we play a trick by getting help from Application events such as App_Sheet Change that can write to cells.
Other references are updating fine though, it is just this one [email protected] Williams Both Ctrl-Alt-F9 and Ctrl-Alt-Shift-F9 updated the cells and made it so they are updating correctly. I searched the Excel Help and found this in the help article titled I had a similar issue with a VLOOKUP.
After saving and reopening, the spreadsheet is still working correctly. The field I was using to VLOOKUP was formatted as a custom field. Clearing this error (selecting all fields with the error, beginning with the first one with the error and clicking change to Number even though I didn't really want it to be! the ctrl alt f9 , is the temporary solution , going to options-formula-auto calculate is the right way, that option turned manual, because some shortcut key on being pressed by mistake turns automatic to manual Thank you for your interest in this question.
The formula is: Everything else is updating in the spreadsheet. The value displayed is the value before I updated the information on Main Copy.