ramaley@csli.Stanford.EDU (Alan Ramaley) (03/23/91)
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