G
Guest
Excel 2003 (Standard) SP2, Windows XP Pro SP2
My project, essentially, searches a 1500 row by 50 column spreadsheet for
keywords and stores values for a half-dozen-or-so cells in an array of
User-defined type. The keywords are loaded into a listbox, the user picks
1-or-more, and data about cells related to those keywords is extracted from
the array.
Here's the thing: Sometimes (*not* repeatably), when I open the workbook and
select from the listbox I get results that are slightly incorrect (e.g., a
keyword actually occurs 56 times, but is reported to occur 52 times). If
open the VBE and run the Workbook Open code, I get the correct result.
The only explanation I can generate, and I grasp at a straw here, is that
the spreadsheet is so laden with formulas (the root of the project is to
speed it up by converting major portions to code) that initial calculation is
interfering with my code. But there's a problem with that theory. I can
trigger the control again, and still get a bad result.
If anyone has any ideas, I'd really like to hear them. Thanks.
My project, essentially, searches a 1500 row by 50 column spreadsheet for
keywords and stores values for a half-dozen-or-so cells in an array of
User-defined type. The keywords are loaded into a listbox, the user picks
1-or-more, and data about cells related to those keywords is extracted from
the array.
Here's the thing: Sometimes (*not* repeatably), when I open the workbook and
select from the listbox I get results that are slightly incorrect (e.g., a
keyword actually occurs 56 times, but is reported to occur 52 times). If
open the VBE and run the Workbook Open code, I get the correct result.
The only explanation I can generate, and I grasp at a straw here, is that
the spreadsheet is so laden with formulas (the root of the project is to
speed it up by converting major portions to code) that initial calculation is
interfering with my code. But there's a problem with that theory. I can
trigger the control again, and still get a bad result.
If anyone has any ideas, I'd really like to hear them. Thanks.