I am writing an Excel file that uses VLOOKUP, INDEX, and MATCH functions to look up information in other sheets, that I am also writing. As I come into the spreadsheet, the values are shown as #VALUE. If I go up to the top and view my function, all I have to do is hit enter at the end, and then the correct value will display. I played with the HSSFFormulaEvaluator some, but since those 3 functions aren't supported yet, that didn't work either. So my last option was to create a macro that would just go hit enter on all those cells, hopefully showing my values immediately. I'm not sure how to do this, however. Is it possible to have a macro run upon opening the spreadsheet created totally in HSSF?
Thanks, Lauren __________________________________________ The information contained in this message may be privileged and confidential and protected from disclosure. If you are not the intended recipient of this message, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message, and please delete it from your computer.
