[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Macro
From:       Lauren Riley <Lauren.Riley () FBLFinancial ! com>
Date:       2008-01-07 19:16:17
Message-ID: OFEC1C6ADF.0091E693-ON862573C9.0069896A-862573C9.0069DB35 () fbfs ! com
[Download RAW message or body]


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.=


[prev in list] [next in list] [prev in thread] [next in thread]