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?
|