worksheet_deactivate event if duplicate found

[HaroonSid]

hi,
in sheets("Rante").range.("ba2:ba500") found any duplicates value and sheet goes to deactivate then

appear a msg "duplicate found" and reactivate the sheets("Rante")

thanks
hope some one will help

[davesexcel]

Hard to deactivate a sheet, you need to select a different sheet.

Anyway, here is a code. When you activate the sheet, it will check out if there are duplicates and tell you.

Please Login or Register  to view this content.

[HaroonSid]

Hi,
thanks for the reply

its working very well but i just want to that when i click on MsgBox (ok). it select the cells which one has duplicate value

[davesexcel]

Change the code to do what you require.