Getting run-time error 13 type mismatch

Hi friends,

If there is a dash sign in column ‘O’ then I don’t want a duplicate message; exit sub. I’m getting run-time error 13 type mismatch.

Please Login or Register  to view this content.

Thank you.

No, it's also not allowing dash sign. If there is no outward number then I want to put a dash sign which may be duplicated. I don't want to count it as duplicate value.
[code
If Target.Value = "-" Then Exit Sub
[/code]

Thanking you,

Please Login or Register  to view this content.

The red line you need to correct because this is not correct syntax. Target.column needs to be numeric.

Hi Bakerman2,
Thank you. Same error on
If Target.Column = "-" Then

What change should I do to make it numeric the red lines?

Please suggest me.

Thank you.

Come on, you have 1210 posts so you should know by now that this "-" is an invalid syntax for addressing target column.
Columns start from 1 to ... depending on which version of XL used.
What exactly are you trying to achieve by using this "-" ?

Sometimes there is no outward number for an entry because it is not posted by post or courier. If the item is issued by hand then there is no outward number. In this case instead of leaving the cell blank I put a dash sign. It may repeat; which should not be treated as duplicate.

Thank you.

This should do it.

Please Login or Register  to view this content.

Hi Bakerman2,

Excellent! It's working fine.

I appreciate you for the same.

Thank you and have a nice time.

you're welcome and thanks for rep+.