Quote:
Originally Posted by rdcsfd
Hi Bjorn:
Thanks for the reply. I did not write that function. I found it on the Internet. It was so slow I turned off automatic calculation. This on a Dell workstation with twin Xeon processors and 8GB of memory. I removed LastInRange="" and that improved the speed, but it still takes 2-3 minutes to calculate this function 10 times on a worksheet.
Are you saying the LastInRange function I posted is working fast on your machine?
|
yes, it works very fast on my machine. Just about a second (or even less) for one update.
Could you please answer the questions in my previous reply, in order to understand what result you want back (since my function and your function are returning different things).
Could you perhaps also post your Excel sheet (or at least relevant parts of it), and let me try if it is slow also on my computer?
Kind regards
Bjorn