=Last(L$22:L$50)

[bobo17]

Using Excel 2000 (9.0.2720)

Hi I am still "reverse" engineering the formulas in this DRIP (dividend reinvestment) spread sheet that someone designed, to understand how it is working.

The above formula =Last(L$22:L$50), the way I "understand" it says, check the column L rows 22 to 50 and return the last value in that colum, i.e. if the last data entered is on row 45, that data will be returned and put into the cell where the formula is. It works in the spread sheet.

My problem, I am trying to "reproduce" these formulas to understand them and I use the =Last comand and it returns the error message: #Name? If it works in the spreadsheet I got why does it not work when I try to "reproduce" it in a new spreadsheet, in other words the version of excel i am using correctly executes the formula on the spreadsheet i got from a web site, but does not seem to work when I try to reproduce it.

Do i understand the formula correctly? and why does it not work when trying to reproduce.

thanks
bobo

 

[bobo17]

Yes
There is a user defined function called "Last"
and then asks the user to enter the range.

I guess there is code somewhere that defines this function?

thanks
bobo

P.S. this Casey Anthony trial is consuming all my time