On 7/28/2009 3:51:52 PM, johanpg wrote:
> he still have
>the same errors:
>
>Line 22, 23 , 28 �
How can he have errors at three lines? When the script encounters an error it exits.
what is the error message he gets?
>He is also asking me:
>
>Is there a file that defines
>the properties of each species
>that I�m missing, as the pr,
>qr values are not defined?
Well, they are not defined because the listboxes don't work.
>I think it could be something
>related to his settings but I
>don't know.
Check "Tools", "Preferences", "Script Security".
>Another question, how could I
>make my calculations quicker,
>because like you saw, this
>calculations are simple but
>take a heck of time...
The listboxes take a long time to calculate. You seem to have some that are duplicates, so you could reduce the number. You could also switch to the other way of saving the state. Because it doesn't write to the metadata it is much faster (on my machine about 6.5 times faster). See the attached for a comparison. Scroll to the end, then hit Ctrl F9 to recalculate everything and look at the times. I suspect the operation of writing the metadata may slow down as the worksheet size increases too. The listboxes in your sheet seem to take longer to calculate than the ones in this sheet.
Richard