From poi-user Mon Jan 07 19:16:17 2008 From: Lauren Riley Date: Mon, 07 Jan 2008 19:16:17 +0000 To: poi-user Subject: Macro Message-Id: X-MARC-Message: https://marc.info/?l=poi-user&m=119973341429645 MIME-Version: 1 Content-Type: multipart/mixed; boundary="--0__=09BBF95ADFFA0FFA8f9e8a93df938690918c09BBF95ADFFA0FFA" --0__=09BBF95ADFFA0FFA8f9e8a93df938690918c09BBF95ADFFA0FFA Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable I am writing an Excel file that uses VLOOKUP, INDEX, and MATCH function= s 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 th= e 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 disseminati= on, distribution, or copying of this communication is strictly prohibited. = If you have received this communication in error, please notify us immedia= tely by replying to the message, and please delete it from your computer.= --0__=09BBF95ADFFA0FFA8f9e8a93df938690918c09BBF95ADFFA0FFA--