Compare text with "<" or ">"

[lgillet]

Hi all,

I have an issue comparing the text content of cells:
the 2 adjacent cells A1 and B1 contain for example:

1. VLSN[115.03]N[115.03]SDANLELINTWVAK
   VLSN[115.03]NSDANLELINTWVAK

1) If you write in a cell:

Please Login or Register  to view this content.

=> you get FALSE since "[" comes before "S" in the alpha sorting of excel.

2) But if you do similar comparison in a VB macro:

Please Login or Register  to view this content.

=> you get TRUE?!?

I don't get it?!?
Do someone has an explanation for that or am I doing something fundamentally wrong???

Thanks in advance for your help and/or comments.
Ludo

[Andy Pope]

Have a look in the help at the

Option Compare Statement



Sorry arthurbr missing the infractions post

[lgillet]

Hi,

the declaration (before the code of the module) of

Please Login or Register  to view this content.

solved my problem.

Thanks a lot for the super-fast reply: your forum ROCKS!!
(and sorry for the infraction about the code quoting).

Ludo