Why the cursor is moving to the next column?

[mso3]

Hi friends,

If there is a duplicate value in column ‘B’ then I don’t want to move the cursor to the next column ‘C’; else if it’s not a duplicate value then move the cursor to the next column ‘C’.
I’m not getting required output in the following code ‘case 2’

Case 2
If (WorksheetFunction.CountIf(Range("B:B"), Target.Value)) > 1 Then
Application.Undo
Exit Sub
Else
Target.Offset(, 1).Select
End If

Any help will be highly appreciated.

Thanking you,