Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!sdd.hp.com!spool.mu.edu!snorkelwacker.mit.edu!stanford.edu!csli!ramaley
From: ramaley@csli.Stanford.EDU (Alan Ramaley)
Newsgroups: comp.sys.mac.apps
Subject: the best way to find blank space in excel?
Message-ID: <18375@csli.Stanford.EDU>
Date: 22 Mar 91 17:21:39 GMT
Organization: Center for the Study of Language and Information, Stanford U.
Lines: 33

I've written a group of macros for a mailing list in excel.  One thing I need
to do is be able to find the next blank row for adding new addresses.  I've
been doing this:

=select("Cn")
=formula.find("",1,1,1,1)

And it usually works.  But on new documents, where the first blank
line is one that's never been written on, I get a "formula not found"
error.  I've also tried this code

=select("Cn")
=if(isblank(active.cell),goto(next_part),select("R[1]C"))
=goto(previous line)

But it's far too slow to be useable!  And, you can't use a database
lookup function, because a lookup using "" will match everything.

If you have any suggestions, could you email me them?  In exchange for
the knowledge I'll give you a copy of my mailing list of record
labels, with almost 800 entries.

--
Alan Aitken Ramaley
(415) 497-5265, P. O. Box 9217, Stanford, CA  94309
Senior, Symbolic Systems
Aquarius

-- 
Alan Aitken Ramaley
(415) 497-5265, P. O. Box 9217, Stanford, CA  94309
Senior, Symbolic Systems
Aquarius