OO-Basic: Macro "last"

Grzesiek Sójka <[email protected]>
Newsgroups gmane.comp.openoffice.questions
Message-ID <[email protected]>
Hi there.

I desperately need a macro (preferably in OpenOffice Basic) returning 
value of the last non-empty cell specified. More precisely let  our 
sheet look as follows:
   |A|B|C|D|E|F
--+-+-+-+-+-+-
1 | |6| |1| |
In this case: LAST(A1;C1;D1;F1)=1 and LAST(A1;B1;C1)=6. In the case when 
all cells specified are empty LAST should return 0. Moreover it should 
accept variable arguments number (like SUM but without the possibility 
of specifying regions).

Thanks in advance for any help.

Regards
Greg
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.