🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.apps
Article #6888

how to tell when an excel command fails?

#6888
From: Alan Ramaley
Date: Wed, 23 Jan 1991 23:45
21 lines
1397 bytes
The place where I do excel macro programming is very far away from my
school's main computer cluster, where all the excel manuals are, when
I'm doing macro programming, so pardon me if this question is on page
2...

How can you tell from a macro when a data.find command has failed?
I've written a mailing label database that looks a list of partial
addresses, and if the partial addresses aren't part of an address in
the database, the macro makes another worksheet with those addresses,
so I can go try to look them up.

I want to do two things.  I want to (1) suppress the 'Couldn't find
it, OK?' message, because I don't want to keep slamming return all the
time, and I want (2) to branch to a different part of the macro
depending on whether or not I found what I was looking for.  This is
with the data.find command (I think).

Send email, pleez, or post; whatever churns yr butter.

-- 
--Alan
Technical Details
Message-ID: <17408@csli.Stanford.EDU>
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!thunder.mcrcim.mcgill.edu!snorkelwacker.mit.edu!usc!sdd.hp.com!ucsd!ucbvax!agate!shelby!csli!ramaley

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!thunder.mcrcim.mcgill.edu!snorkelwacker.mit.edu!usc!sdd.hp.com!ucsd!ucbvax!agate!shelby!csli!ramaley
From: ramaley@csli.Stanford.EDU (Alan Ramaley)
Newsgroups: comp.sys.mac.apps
Subject: how to tell when an excel command fails?
Keywords: excel
Message-ID: <17408@csli.Stanford.EDU>
Date: 23 Jan 91 23:45:13 GMT
Organization: Center for the Study of Language and Information, Stanford U.
Lines: 21