lastincolumn function

BjornS · #1 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

it4728 · #2 02-08-2012, 07:50 AM

Hi,

I am facing a problem whereby i am trying to use the lastincolumn function to copy the last value in a column of a workbook into a new workbook. It requires me to open the workbook that I am copying from for it to work or to be updated. Is it possible to use the lastincolumn function without the need to open the workbook that i am copying, that is, to get the last value in a specific column in a closed workbook?

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