Thread: [Solved] lastincolumn function
View Single Post
 
Old 01-31-2010, 04:27 PM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Quote:
Originally Posted by rdcsfd View Post
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
Reply With Quote