lastincolumn function

BjornS · #5 01-31-2010, 04:27 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cross-reference function with Visio?	Barometer	Word	0	11-04-2009 12:38 PM
Outlook 2003/ Send to function	ptservice	Outlook	0	09-24-2009 07:09 AM
Help! for using an appropriate function/Macro in Excel	pawan2paw	Excel	1	06-04-2009 12:28 PM
Need help on what function to use???	Primeraman	Excel	1	06-13-2006 10:16 AM
Help with Combination function	sanasath	Excel	0	12-13-2005 07:24 AM