Error in macro search

pepito121 Posts 1 Registration date Tuesday November 4, 2014 Status Member Last seen November 4, 2014 - Nov 4, 2014 at 07:31 AM
I made a vba macro to retrieve data from a database in Excel. if the data is not found; I get an error message and I have to restart the macro again. How can I catch error so it is not necessary to have to reboot the macro