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