Article View: comp.sys.mac.apps
Article #6888how to tell when an excel command fails?
From: Alan Ramaley
Date: Wed, 23 Jan 1991 23:45
Date: Wed, 23 Jan 1991 23:45
21 lines
1397 bytes
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!ramaleyShow 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