Error handling while uploading data into Oracle DB

Hi,

I am new to macros and trying to upload data using macro row by row. Now say one of the rows has an issue with data and my macro code threw error, i want to handle this error in the following manner. I want to highlight this row with some colour. Also i want my code to start processing the next row of the sheet. Can this be done? Please help.

For example take i have total of 100 data rows in a sheet which i want to upload to the database. Say 23rd row had data problem and my marco code threw error. I want this 23rd row to be highlighted in a different colour. and i want my code to continue from next row. how can i achieve it?

below is my macro code.

Please Login or Register  to view this content.

Regards
Puru