title: vba PULL function speed up
body: <p>I am using the PULL function (<a href="http://groups.google.com/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd?pli=1" rel="nofollow">http://groups.google.com/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd?pli=1</a>) which is like INDIRECT except that it can reference a closed workbook.  </p>
  
  <p>The PULL function works fine, except that it creates an excel instance every time it is called and that makes calculation of the workbook with many calls extremely slow.</p>
  
  <p>Is there a way to re-write this function such that it will run significantly faster?</p>