Re: performance question

you must remember with a formula, you also have a link (since something change in a book, your formula gives the new value)

If you need the value, you may evaluate the string, without writting it first in a cell (vba function evaluate)

 But, if this link is precious, the formula is probably the better way.


Whatever, you should look on the web the way to list a folder, so you'll be abble to construct this formula with a loop (and not the explicit names). I don't know the rest of the code, just a suggestion that might help
.

Relevant Pages

  • Re: [patch] CFS scheduler, v3
    ... suggestion: the ratio between a nice 0 loop and a nice 19 loop is now ... for a real user interface. ... What's appropriate for end-users is a very different thing from what ...
    (Linux-Kernel)
  • Re: DO loop standards question.
    ... > integer type of the control variable is non-conforming? ... interp that prompted the more explicit wording - I forget). ... The standard says that the iteration count is computed ... symptoms like making the loop infinite). ...
    (comp.lang.fortran)
  • Re: Exceeds amount of items
    ... Declare all objects explicitly and release them each pass through the loop ... foreach() loop, the foreachis not only slower but also creates hidden ... Instantiate an explicit object for each dot operator, ... if goto notmatch; ...
    (microsoft.public.outlook.interop)
  • Re: How can I speed up this code?
    ... I code this up and the results were a three times speedup in the explicit for loop version. ... Elapsed time is 3.899740 seconds. ... explicit for loop -- mex ...
    (comp.soft-sys.matlab)
  • Re: Poor performance during tasks adding
    ... powerful...but the database structure seems quite complicated, ... > tasks to a project in which I created many custom fields and outline ... > myproj1.Tasks collection at the botton of the loop. ... > Any suggestion will be very valued!!!! ...
    (microsoft.public.project)