Compare value / text of a cell

[plans]

Hello,

I am using the following code:

Please Login or Register  to view this content.

This works fine as long as cell A1 does not contain a string longer than 256 characters.
Is there a workaround?
I can not split the cell - it would make it very cumbersome.
Could you please advise?

[Croweater]

Have a read of this;

https://support.microsoft.com/en-us/...rs=en-us&ad=us

They are saying for long strings use CONCATENATE or & to break up the long string. I've never tried it/tested it though.

[plans]

OK, I got this..., using the:

Please Login or Register  to view this content.

CODE] If StrComp(str1, str2, vbBinaryCompare) = 0 Then

Please Login or Register  to view this content.

Thanks