Regular expression with Cyrillic characters

[Vixx1]

Hello Experts,
it is possible to use regular expression to find 2 Cyrillic character ? Like [A-Z][A-Z] (uppercase)

[jindon]

Perhaps

Please Login or Register  to view this content.

[Vixx1]

Jindon you'are solving all my problems in excel heh, real forum guru, its connected to last task but ive got 6 files that contain cyrillic characters
(Not Cells(i, 4).Text Like "*[A-Z]*")) -< this [A-Z] need to replace for cyrillic chracters, how to use this pattern with that

[jindon]

It is not a Regular Expression. It is just a Like operator and the character set with wild card.

You said "Regular Expression", that is totally different object...

[Vixx1]

sorry im not so close to IT stuff it is possible to find 2 cyrrillic char in this case?

[jindon]

Then one idea to create a function using Regular Expressions like

Please Login or Register  to view this content.

The you can call it from other procedure like

Please Login or Register  to view this content.

[Vixx1]

Please Login or Register  to view this content.

How can i connect your code with this one ( also your code )

[jindon]

Thanks for the code tags.
Can not test, so not really sure

Please Login or Register  to view this content.

[Vixx1]

DOne, sorry

[Vixx1]

Sub or function not defined in code it look like this ( i made few cosmetics changes up to my file ) :

Please Login or Register  to view this content.

[jindon]

Missed "e", should read as

Please Login or Register  to view this content.

[Vixx1]

its working ! thanks