Upper case or lower case

[haseft]

Hi!
I have a table and searching for a text.
The value of ActiveCell.Offset(0, 3) is “1-ÅRIGT ÅTAGANDE”
This text can change time to time, some time has upper case, and sometime has lower case.
I want to match no matter upper case or lower case (without sensitivity).
Please help!

Sub test()
If ActiveCell.Offset(0, 3).Value = "1-årigt åtagande" Then
'some codes
Else
'som codes
End Sub

 

[joeu2004]

If LCase(ActiveCell.Offset(0, 3).Value) = "1-årigt åtagande" Then

 

[vcoolio]

Hello Haseft,

Place this:-

Option Compare Text

above

Sub test()

I hope that this helps.

Cheerio,
vcoolio.

 

[haseft]

tanks to both, its workning nu.

 

[vcoolio]

You're welcome Haseft.

Cheerio,
vcoolio.