If duplicate is found in column B, delete Row, if not, msgbox and exit

**VBA FTW** · 02-17-2013, 06:53 PM

I can search column B and delete the row if a duplicate has been found, but I can't figure out how to show a message box and exit the procedure if a duplicate isn't found. Can someone offer a little help?

Please Login or Register  to view this content.

How can I adjust this to exit sub and show a different message box if a duplicate isn't found in column B?

**jeffreybrown** · 02-17-2013, 07:52 PM

You could check the last row after the For Next and if the same then exit the sub...

Something like...

Please Login or Register  to view this content.

**VBA FTW** · 02-18-2013, 10:33 AM

...i'll be back

**VBA FTW** · 02-18-2013, 11:32 AM

Thank you for your help Jeff, I think I have this sorted out. Many thanks

**jeffreybrown** · 02-18-2013, 11:34 AM

You're welcome…glad you have a workable solution and thanks for the feedback...

If duplicate is found in column B, delete Row, if not, msgbox and exit

LinkBack

Thread Tools

Rate This Thread

Display

If duplicate is found in column B, delete Row, if not, msgbox and exit

Re: If duplicate is found in column B, delete Row, if not, msgbox and exit

Re: If duplicate is found in column B, delete Row, if not, msgbox and exit

Re: If duplicate is found in column B, delete Row, if not, msgbox and exit

Re: If duplicate is found in column B, delete Row, if not, msgbox and exit

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions