Article View: comp.sys.mac.apps
Article #7967the best way to find blank space in excel?
From: Alan Ramaley
Date: Fri, 22 Mar 1991 17:21
Date: Fri, 22 Mar 1991 17:21
33 lines
1471 bytes
1471 bytes
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
Technical Details
Message-ID:
<18375@csli.Stanford.EDU>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!sdd.hp.com!spool.mu.edu!snorkelwacker.mit.edu!stanford.edu!csli!ramaleyShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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