Check if Activecell Value containts "º" symbol

[brainzlp]

How can i see if the activecell contains "º" (this symbol)

Need something like:

Please Login or Register  to view this content.

thanks in advance

[walruseggman]

Please Login or Register  to view this content.

[brainzlp]

i had simular solution, but it's giving me error.

I had this:

Please Login or Register  to view this content.

[brainzlp]

It says object required, and highlights this:

Please Login or Register  to view this content.

[walruseggman]

Hard to say, I don't know what any of your variables are. I would guess that CelulaSecçãoAtual is not an object, though.

Posting your worksheet and the whole Sub would lead to the fastest solution.

[brainzlp]

duplicated, sorry.

[brainzlp]

Hard to say, I don't know what any of your variables are. I would guess that CelulaSecçãoAtual is not an object, though.

Posting your worksheet and the whole Sub would lead to the fastest solution.

I figured it out already, celulasecçãoatual was not an object as you mentioned. Thanks , it's already working.

Do i need to put the "1" infront of "º" in the instr formule?

it's the vbcompare

Have a nice day

[walruseggman]

I believe the 1 is optional, it's the position in the string you want InStr to start at. I believe 1 (the first character in the string) is the default

[brainzlp]

i removed it and it's ok. It's a comparison mode for database, binary something and so on. Without the 1 it works.

Thanks for your help