Hi folks. Does anyone know how to search a sheet for a particular
reference (could be anything)... and if that reference does not exist,
then... 'do something else'. When you do a 'find' manually, and the
thing you're looking for doesn't exist... excel let's you know. But
when you try and do this in VB... if the reference isn't found, Excel
just continues running the code. Hope that makes sense.